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

Question

No Solution appears for: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Is this error also comes in the paid vesion of Visual Studio? Or it is by intention

Answer 1

Please check which Ms Office version is installed. If it is 32 bit then compile your visual studio in 32 bit (X86) and not in “Any CPU”. If it is 64 bit version, then compile your visual studio solution in X64 CPU. Click on “my project” in right side-compile (Second Option in 20117) on left side option-target CPU option as X86 or X64 as required. This will solve the oled 12 problems. If not, first install “AccessDatabaseEngine” as per your requirement, then select compile option as discussed above.