Description

When an Access 2016 Database is opened, an error message is received: 

10.7.2 & 10.7.3: 
An error has occured while opening database. The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.


11.2:
Please install driver for ODBC Data Sources

Applies To

10.7.2, 10.7.3, 11.x

Cause

The error occurs when the "Microsoft.ACE.OLEDB.12.0 provider" hasn't been registered on the machine where the application is running. The ACE provider is not installed on Windows operating systems by default. 

Solution

First check to see if the database engine is the same bit as the version of Access installed - this error will occur if the bits are mismatched. 

Download & Install: "Microsoft Access Database Engine 2010 Redistributable".

Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel. 

To install:

1. Download the file by clicking the Download button and saving the file to your hard disk.
2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
3. Follow the instructions on the screen to complete the installation.

Link: https://www.microsoft.com/en-us/download/details.aspx?id=13255

Additional Information

 https://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?forum=vstsdb