Fix - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.

Following article describes, how you can fix an error "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine". Usually, you might face this error while using MS Access 2007 or higher with OLEDB connections. It's because Office 2007 (and higher versions) requires OLEDB ACE drivers for connection. By default, the OLEDB ACE drivers wont be installed on Windows operating systems. To get this error fixed , you will need to install OLEDB ACE drivers manually.

 

Mainly the ACE providers are available in two forms: Microsoft Office Access database engine 2007 and Microsoft Access Database Engine 2010 Redistributable. First version is only available with 32-bit component. The second version offers both 32 and 64-bit options. In most cases, 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 the 32 bit applications and should work most of the times. If they don't work, try downloading Microsoft Access Database Engine 2010 Redistributable. Once you click download button, it will prompt you to select from 32 BIT (x86) architecture or 64 BIT (x64). If you are running Visual Studio or MS SQL Server of 32- bit architecture, you should choose 32 bit file or else 64 - bit file.

→ Facing an error with MICROSOFT OLE DB PROVIDER - ERROR '80040E10? Please refer to fix Microsoft OLE DB error for more details.

Related Articles

How to open Firewall Ports on Windows Server 2012?

Following article will help you to open ports in Windows Firewall with Windows Server 2012...

Why do my email receipients receive (?????) question marks when I send emails using Arabic text?

Sometimes, emails sent through the SmarterMail containing Arabic texts, show the question marks...

I am unable to connect to my Windows VPS through RDP.

There could be plenty of reasons for not being able to connect to Windows VPS via Remote Desktop....

Is there any limitation in Table Numbers in Microsoft SQL Server database?

Depending on SQL server edition and environment, there will be limitation. Please refer to the...

How to Install Telnet Client in Window and Linux?

Telnet Client allows you to connect to remote and local computers via Telnet protocol. Telnet...

  • 0 Users Found This Useful

Was this answer helpful?