Microsoft.ACE.OLEDB.12.0 provider is not registered

Question

My application is written in C# and uses Ms-Access 2003 and I want it to run properly in 64-bit Windows installation. I use the data provider as ACE.OLEDB.12.0 in the connection string, but it still gives the exception that Microsoft.ACE.OLEDB.12.0 provider is not registered though I have installed the Microsoft Access Databse Engine 2010 (32-bit) in the target machine (As the target machine's Office installation is 32-bit).

I followed to the following post Microsoft.ACE.OLEDB.12.0 provider is not registered and many other posts in msdn and other microsoft sites and the problem solves as they say to compile to x86. I want to know whether there is another way of solving this problem which does not require compiling to x86...

Answer 1

You don't have to compile for x86, but you need to install the 64-bit Access OLEDB provider on a 64-bit box. It's available here: Microsoft Access Database Engine 2010 Redistributable

Answer 2

I had this same issue on a 64-bit, but following advice on http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine, I installed the Office 2007 version of these components from http://www.microsoft.com/download/en/confirmation.aspx?id=23734, which worked flawlessly.