topic The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine in Product Forum

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

kirtish.trivedi — Wed, 07 Dec 2022 04:03:00 GMT

Hi All,

I am using Data: OLEDB to connect Excel as database. It is working fine in STG and DEV but not in PROD
and throwing below error

Error Detail : Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Error Stage : Data - OLEDB::Open

I found below link in Blueprism OLEDB guide to install access database Engine but link doesn't work. Could someone please guide ?
https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

------------------------------
Kirtish Trivedi
------------------------------

RE: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

PvD_SE — Wed, 07 Dec 2022 12:19:00 GMT

Hi Kirtish,

As you already deducted, it is a problem in PROD. Something 'Officy' is either missing or wrongly configuered.

If you google the error you get, you'll find many pages describing different solutions on how to install/fix the problem in PROD.

------------------------------
Happy coding!
---------------
Paul
Sweden
------------------------------

RE: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Walter.Koller — Wed, 07 Dec 2022 13:49:00 GMT

Hi,

try this link for downloading Access Database drivers:
https://www.microsoft.com/en-us/download/details.aspx?id=54920

However, those driver might work but is not the suggested solution for later version of Office.
Please read here for details on Microsoft 365
https://learn.microsoft.com/en-us/office/troubleshoot/access/cannot-use-odbc-or-oledb

------------------------------
Walter Koller
Solution Manager
Erste Digital / Erste Group Bank
Europe/Vienna
------------------------------