x64 Jet Provider

Started by PaulSamuelson, December 05, 2017, 01:57:37 PM

Previous topic - Next topic

PaulSamuelson

I use the following code, or variations on it, all the time with compiled 32-bit scripts.

cat = ObjectOpen("ADOX.Catalog")
cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=":JobMDB:";"
cConn = cat.ActiveConnection
RS1 = ObjectOpen("ADODB.Recordset")
RS1.Open("tblImages",cConn,3,3,-1)


Now I would like to move some of them to x64, but I get a 1261 "Provider could not be found" error. Is there some alternate code I need to run to work with Access files with 64-bit code?

Thanks,

Paul Samuelson


td

I don't believe that MSFT installs a Microsoft.Jet.OLEDB.4.0 64-bit provider as part of an Office package.  Microsoft considers the old Jet provider obsolete.  Microsoft does have a download for the  64-bit Access Database Engine for non Microsoft applications which supports the ACE provider (Provider=Microsoft.ACE.OLEDB.12.0;).   You could also consider a 64-bit ODBC driver for your specific non-Office data source.

The download link:

https://www.microsoft.com/en-us/download/details.aspx?id=13255
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade