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

Microsoft.ACE.OLEDB.12 Provider is not registered

Scenario:

Windows 7, Office 2013, and Visual Studio 2010 VB.net with the following lines in your code:

myConn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\salesreportdb.accdb")

...

fails at the connection.open statement.  See the debug session error message:


Failure During Debug. Unregistered.

The Fix:

First, install the 64 bit version of Access Database Engine 2010 by using the standard installer.  Then install the 32 bit version of the AccessDatabaseEngine 2010 runtime with the /passive switch on the command line.  Specifically, download the 32 bit version of Access Database Engine, using this link:  https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255  Finally install the 32 bit edition using the /passive switch.

In your visual studio project change the compile settings to 32 bit.  Then change back to AnyCPU.  This part is optional. Re-run it.  

Meaning:

This means that the Provider is not registered in the ODBC properties.  In the control panel 


Comments

Popular posts from this blog

Microsoft Visio 2010 Premium Product Keys

Fix: The Diagnostic Service Host service failed to start due to the following error. [ solved, no kidding ]

Mercedes Benz Diesel CDI EGR Emulator Circuit Diagrams