Posts

Showing posts from September, 2021

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

Image
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: 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...