Fix error "The Microsoft.ACE.OLEDB Provider Is Not Registered On The Local Machine."

News Knowledge Base
1

How to fix the error "Microsoft.ACE.OLEDB provider is not registered on the local machine." with Database activities.

Issue Description:
Certain activities such as MS Access, etc. will require a connection to a data source and may at times require the customer to reinstall/update the ODBC driver. An issue might occur if the 32-bit driver installer detects other 64-bit Office products in the environment.

Resolution:

  1. Uninstall the 64-bit Office products, install the 32-bit driver, and reinstall the 64-bit Office products. See the Cannot Install 64 Bit Office With 32 Bit documentation for more information.
  2. Run the 32-bit driver installer in 'quiet' mode.
    1. Download the Microsoft Access Database Engine 2016 Redistributable.
    2. Open the Command prompt as Administrator.
    3. Provide the full path of the .Exe file and add '/ quiet':
  • C:\Users\username\Desktop\AccessDatabaseEngine.exe /quiet

See the Microsoft Access Database Engine 2016 Redistributable Wont Install Due To 64 Bit component for more info.