View All Blog Posts

Resolving Microsoft.ace.oledb.12.0 Provider is Not Registered on the Local Machine

How to fix the microsoft.ace.oledb.12.0 provider is not registered on the local machine error

When connecting to a Microsoft Access database, you may see an error message stating: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

If this appears, there is no need to panic as you have a couple of options to resolve this:

1- Install the Microsoft Access 64-bit driver
2- Enable the Feature in Windows
3- Run the 32-bit version of the Software

Driver Error

Install the Microsoft Access 64-bit driver

One way to resolve this error and not see the issue again is to install the Microsoft.ACE.OLEDB.12.0.NET Client Library. This can be found in the Office 2010 runtime for the OleDB driver (64-bit version).

You can find the download on the Microsoft Webpage here: https://www.microsoft.com/en-gb/download/details.aspx?id=13255

Enable the Feature in Windows

To enable this feature in Windows type the following into a command line:

dism /online /Enable-Feature:Windows-Identity-Foundation.

When using Windows or Windows server you will need to enable the feature from the Add/Remove Features utility.

Run the 32-bit version of the Software

Another option is to run the 32-bit version of the software you are trying to use.

For Data Sync you can find the 32-bit version (Simego.DataSync.Studio32.exe) within the program files, specifically at the following path C:\Program Files\Simego\Data Synchronisation Studio 3.0.

If you are also scheduling your projects using the Run Tool then you will also need to use the 32-bit version of the Run Tool as well. You can find this at the same path as for Data Sync and you are looking for the Simego.DataSync.Run32.exe executable.

| Thursday, July 2, 2015 |