Resolving Microsoft.ace.oledb.12.0 Provider is Not Registered on the Local Machine
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
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.
Recent Blogs
- Upcoming Changes to Data Sync and Ouvvi
- Making Dynamics 365 Items Inactive rather than Deleting them
- Performance and Optimisation Strategies for Dynamics Synchronisations
- Creating Dynamics 365 Activity Records
- Setting Content Types on SharePoint List Items
- Importing Documents as Attachments in Dynamics 365
- Scheduled Import and Export for Dynamics 365
- Synchronising Data with Dynamics Navision and OData
- Integrating with Salesforce
- Creating Database Scripts from the Schema Map
- Bulk Update Active Directory
- Managing Active Directory User Group Membership
- Creating New Active Directory Users
- Updating the Active Directory Manager Attribute
- Supporting Mongo DB Connections
- Sending a Data Set as an Email and Email Attachment
- Import, Export and Update Active Directory Contacts
- Exporting & Updating Active Directory Computers
- Synchronising SharePoint Documents and Metadata
- SharePoint List and SQL Table 2 Way Synchronisation
- SharePoint List Data Replication with Ouvvi
- Import Email Messages to a SharePoint Document Library
- Bulk Upload Documents into SharePoint from Excel
- Handling SharePoint Lookup Columns
- Import SQL Table to a SharePoint List
- Synchronise Active Directory Users with SharePoint List
- Import Files into SharePoint Document Library
- Synchronise a SharePoint Folder with the File System
- All you need to know about integrating Podio Apps with your Email Provider
- Updated Dynamics 365, SharePoint & Salesforce Connectors
- Dynamics 365 N:N Relationships
- Download Dynamics 365 Audit History
- The New Run Tool Step Types
- Dynamics 365 Campaign Roll-up
- How to integrate with Case Records in Dynamics 365
- The New and Improved Run Tool
- Creating and Importing Data into Custom Entities in Dynamics 365
- New Active Directory Connector
- Using Ouvvi Apps to Feed Data into Power BI
- Copying Address Records from Accounts to Contacts
- Importing Dynamics 365 Connection Records
- Product Updates October 2020