Alternative to Microsoft.Jet.OLEDB.4.0 for 64 bit access on MDB File

Question

I have like many others the problem that I can't access Microsoft Access (MDB Files) from my 64 bit machine using Microsoft.Jet.OLEDB.4.0.

I know that there's no 64bit version of it, and that I need to compile it against x86.

So my question is: Do you know any other .NET Providers for Microsoft Access that supports 64bit access?

Answer 1

To get 64 bit Microsoft Access drivers download the Microsoft Access Database Engine 2010 Redistributable. You cannot install that with a 32 bit version of Microsoft Office installed.

The ODBC connection string with that driver is "Driver={{Microsoft Access Driver (*.mdb, *.accdb)}};Dbq=%FILE_NAME%;Uid=Admin;Pwd=;". The OleDb connection string for that driver is "Provider=Microsoft Office 12.0 Access Database Engine OLE DB Provider;Data Source=%FILE_NAME%;User Id=admin;Password=;.

Answer 2

For Windows server 2003, there is the MSDASQL that offer an OLEDB provider for ODBC, which can connect to Access. It is available in 64bits.