HOW I SOLVED the error: The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
Advertisements by Google

The solution that you will find everywhere for this error is to install the Microsoft Access Database Engine. If you have the 32bit version of office, then you have to install the 32 version of Microsoft.ACE.OLEDB.12.0. The same applies for 64th version.

But, for me it didn’t worked. So I found on some blogs that I have to install the both versions (32 and 64bit) of Microsoft.ACE.OLEDB.12.0. I started by installing the 64-bit Microsoft Access Database Engine 2010 Redistributable. Normally windows will not let you do that windows will pop up this screen:

ACE engine bittedness error

There are two options for getting the other version installed.

Advertisements by Google

Option A: Install the 2007 Office System Driver: Data Connectivity Components

The 2007 Access database engine can read the same format, but didn’t have a 64-bit install. It doesn’t have the check to see what other products are on your machine and can co-exist peacefully with the 64-bit 2010 Access engine.

Option B: Install from the Command Line and Use the Passive Switch

  1. Open the command prompt.
  2. Type the file path and file name for your Access Database Engine install file.
  3. Follow it with a space and then “/passive” and then hit Enter.
  4. Delete or rename the mso.dll registry value in the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths

Note: A helpful commenter has informed me that for Access 2016 the switch is /quiet rather than /passive.

ACE install cmd

This is how I solved this error: Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine. If it helped you as well please share it.

Advertisements by Google

Related Posts

Leave a comment

Privacy Preferences
When you visit our website, it may store information through your browser from specific services, usually in form of cookies. Here you can change your privacy preferences. Please note that blocking some types of cookies may impact your experience on our website and the services we offer.
%d bloggers like this: