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
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
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.
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.