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
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 (https://www.microsoft.com/en-us/download/details.aspx?id=13255)