This article describes how you can fix the 'Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine error
Usually, you might face this error while using MS Access 2007 or higher versions with OLEDB connections. It's because Office 2007 (and higher versions) requires OLEDB ACE drivers for connection.
By default, the OLEDB ACE drivers won't be installed on Windows operating systems. To fix this error, you will need to install the OLEDB ACE drivers manually.
Primarily the ACE providers are available in two forms –
- Microsoft Office Access database engine 2007
- Microsoft Access Database Engine 2010 Redistributable.
The first version is only available with a 32-bit component. The second version offers 32-bit and 64-bit options.
In most cases, the incorrect choice is the cause of this error. Hence, you should be more careful while choosing the correct option from these options.
The 2007 Office System Driver Data Connectivity Components are only available with 32- bit components. They are most suitable for 32-bit applications and should work most of the time. If they don't work, try downloading Microsoft Access Database Engine 2010 Redistributable.
Once you click the Download button, it prompts you to select from 32-bit (x86) architecture or the 64-bit (x64) architecture.
If you are running Visual Studio or MS SQL Server of 32- bit architecture, you should choose the 32-bit or 64-bit file.
→ Facing an error with Microsoft OLE DB PROVIDER - ERROR '80040E10?
Please refer to Fix: Microsoft OLE DB error for more details.