'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Microsoft.ACE.OLEDB.12 Provider is not registered
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:
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.
This means that the Provider is not registered in the ODBC properties. In the control panel