Search code examples
c#ms-access-2010oledbexception

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Error

Currently, I am trying to run my c# code on my Windows x64 platform. But I cannot add my data into the MS Access. Its saying Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.. I tried to check my office application versions and got to know they are 32 bits application.

I tried to search for some solution but it didnt worked for me. This are the methods I have tried:

  1. Installing Microsoft Access Engine 2010
  2. Changing it to Microsoft.Jet.OleDb.4.0 (still the same error pops up)

This is my connection string code:

Connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\FacesDatabase.accdb;
                                        Persist Security Info=False";

Can I know how to solve this error. Thank you

Solution

  • If you're using 64-bit but still having problem even after installing AccessDatabaseEngine, see this post, it solved the problem for me.

    ie. You need to install this Access Database Engine

    Kindly check and confirm.