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?

How about this : http://stackoverflow.com/questions/122583/64-bit-alternative-for-microsoft-jet/3049332#3049332 — Pratik, Aug 05 '11 at 10:28
That's no solution, because the drivers can only installed if no other 32 bit Office version is already at the pc. But most customers will have a 32 bit office version, like Office 2003 / 2007 and so on. — BitKFu, Aug 05 '11 at 11:43

score 4 · Answer 1 · answered Aug 28 '11 at 20:31

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=;.

Is there no standard support for databases altogether in 64bit Windows? — drgs, Nov 29 '20 at 17:22

score 1 · Answer 2 · edited Jun 05 '13 at 13:43

1

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.

edited Jun 05 '13 at 13:43

Justin Dearing

14,270
22
88
161

answered Aug 05 '11 at 17:55

Pierre-Alain Vigeant

22,635
8
65
101

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

2 Answers2

Linked