Open ms-access .mdb in 32 and 64bit windows using c#

I use a connectionstring like "Provider=Microsoft.Jet.OLEDB.4.0;..." to open a .mdb database. Moving to a 64bit computer this does not work anymore since there is no 64 bit implementation.

My understanding is that it is done this way b开发者_如何学Pythonecause Jet is deprecated. There is one workaround in which you compile your application to run as 32bit only.

What are we supposed to move to?

Is there a new provider that works in both 32 and 64 bit?

Did you try this SO: 64-bit Alternative for Microsoft Jet?

What are we supposed to move to?

SQL Server Express 2008 R2. The move to SQL Server Expres was announced about 10 years ago.

Is there a new provider that works in both 32 and 64 bit?

Your definition of new is 10 years old :)

Change the target platform of the application to x86 instead of 'any cpu'. By doing so, your app will run under WOW64-mode on 64bit systems, and will use the 32bit Jet provider.