Author Topic: x64 Jet Provider  (Read 671 times)


  • Newbie
  • *
  • Posts: 40
x64 Jet Provider
« on: December 05, 2017, 01:57:37 pm »
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")

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?


Paul Samuelson


  • Tech Support
  • *****
  • Posts: 2849
    • WinBatch
Re: x64 Jet Provider
« Reply #1 on: December 05, 2017, 02:38:29 pm »
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:
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade