64-bit driver for Microsoft Access databases

A big thanks to Stephen Preston for passing on this very interesting information. Stephen is one of the "volcanically challenged" members of my team, so fingers crossed he'll be able to get a flight across to the UK in the coming days. Aside from Stephen's delayed trip back to the motherland, the recent travel disruptions have also impacted an Inventor API training class being held in Moscow (which will go ahead with a back-up trainer) and extended another team member's vacation in the Philippines.

The lack of a native 64-bit driver for ODBC, ADO, OLE DB, etc. access to Microsoft Access databases has been a big problem for developers porting their code to support 64-bit, especially as when working within an AutoCAD plugin you're not able to thunk down to 32-bit using WoW64.

Well, there is now a ray of hope breaking the horizon: Microsoft has released a beta version of their Access Database Engine component (abbreviated to ACE, for Access Control Entry) which appears to be an x64-capable replacement for their 32-bit Jet technology.

For more information, please check out this blog post.

One word of warning… I stumbled across a mention of this component not being able to co-exist with 32-bit versions of Office. I haven't tried this myself, but I thought I'd at least pass on that tidbit even if uncorroborated.

13 responses to “64-bit driver for Microsoft Access databases”

  1. Glad they are working on something, this bit me pretty bad, I ended up exporting all tables out of access into xml so that I don't have to rely on any ado adapter.

  2. For what it is worth, I had to do a complete uninstall of the Microsoft Office 2007 32 bit Suite, and a reboot, before I could install the MS Office 64bit 2010 Beta. If I had installed the 2010-32bit MS Office, it would have done an inplace upgrade. I've had several issues, with addins, and some application built on MS Office Excel, not working with 2010, since there is a different name on many of the 64 bit dll files versus their 32bit counterparts.

  3. We made the mistake of posting the link to Office 2010 on our fanpage and regretted it when we had an influx of queries about problems fans had with it!

  4. I moved to SQLite, I can embed a SQLite server directly into an ARX module, now I am in control... the price isn't bad either

  5. Other than the 2007
    Office issue the driver
    works fine with Windows
    7 64 bit and AutoCAD
    2009/2010/2011.

  6. Paul Lloyd-Smith Avatar
    Paul Lloyd-Smith

    Has anyone tried uninstalling their existing 32 bit Office install, installing the 64 bit driver and then re-installing office 32bit? Would it work??

  7. Roberto Amores Avatar

    i also would like to ask the same question as Paul Smith... i am having these problems on my laptop about these drivers...

  8. Sorry not to be stepping in to help - I really don't have any knowledge to share in this area, I'm afraid.

    Kean

  9. *****This Worked for me, but take warning....use at own risk!!!****

    OK.....well I was able to get through all the Microsoft redlights. I downloaded both the 32&64 bit versions of the 2010- Microsoft Office14 Database Engines for MS Access. First I used WinRAR to open the exe file, and extract to a temp folder. After that I used a freeware utility, Universal Extractor, to tear open the msi packages. Once that was done, the second tier installer autoran, and installed the necearry components, without getting stopped by the Office Version Testers.

  10. Worked for me too. I used Orca to change the LaunchCondition variable BLOCKINSTALLATION.
    Not sure why they would block the installation if you have MS Office installed. It must interfere with some aspect of it, but so far it is working fine. You can now add an ODBC access data source.

  11. Simon, thanks for the Orca tip!
    It worked for me with the release version of the Microsoft Access Database Engine 2010.
    Now I have both MSOffice 2003 and the 64 bits ODBC drivers installed and working. For now...

  12. I'm really greatfull to Antrow Software Development as they answered my question about how to move access to a website. 🙂

  13. Why not use SQL Server CE? No install required; 32bit and 64bit binaries provided. SQLite is viable as some else mentioned. MS seems to have decided not to continue development of SQL Server CE, though it is still supported.

Leave a Reply to Daniel Cancel reply

Your email address will not be published. Required fields are marked *