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.