Ms-access – The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine even if it actually IS installed

ms-accessoledbvisual-studio-2015

I try to connect .accdb file as a data source to my Windows Form application in Visual Studio. It keep saying the Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.

Error screenshot plus listed OleDb enumeratos

I have installed all the recommended runtimes on related Answers marked as Accepted/working:

  • Microsoft Access database engine 2010 (x64)
  • Microsoft Access database engine 2016 (x64)
  • Microsoft Access Runtime 2010 (x64)
  • Microsoft Access Runtime 2013 (x64)

but still the same issue.

Setting the x86/x64 platform in Windows Forms project did not help.

Setup:

  • Microsoft Windows 10 64-bit Version 1809 build 17763.437
  • Microsoft Visual Studio 2015 14.0.25431.01 Update 3

Best Answer

There really is strange mixture of platforms. I have installed all the necessary available within 64 bit and the connection resulted in "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine".

When I tried to install the 86 bit version, I got the "You cannot install the 32-bit version of Microsoft Access Database Engine because you currently have 64-bit Office products installed...": Setup Runtime error

I followed the Merav Kochavi's advice to run the also the 32 bit version setup using /passive parameter ("AccessDatabaseEngine.exe /passive") and it went without the error message and now IT WORKS! Test connection succeeded.

Thank you all for help!

Related Topic