Author Topic: x64 Jet Provider  (Read 41 times)

PaulSamuelson

  • Newbie
  • *
  • Posts: 26
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")
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

  • Tech Support
  • *****
  • Posts: 2223
    • 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:

https://www.microsoft.com/en-us/download/details.aspx?id=13255
"Success is a lousy teacher. It seduces smart people into thinking they can't lose."
  - Bill Gates