Discussion:
32/64 bit access to access?
(too old to reply)
Bruce Bowler
2013-10-03 14:13:46 UTC
Permalink
I have 2 applications, one is 32 bit and one is 64 bit. I've got access
2007 installed. The 32 bit app connects to my DB just fine, the 64 bit app
refuses. The connect string I'm using is

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=c:\mydata
\file.mdb

I suspect, based on what I've read elsewhere, that I'm SOL (that's an O
not a Q :-). I'm hoping I missed something in my surfing and someone here
can point me to a connection string, or tool to add, that will let me
interact with the database from my 64 bit app.

Thanks!
Bruce
AaronKempf.com | CareerDBA.com | FullStackWP.com
2021-01-11 10:48:03 UTC
Permalink
you can download the ACCDB / ACCDE database extensions. I just was using it here

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Loading...