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!