this error is very common but in my case, is very strange why is being produced.
I have developed a 64 bits application that uses an Access database. To be able to run it, I installed 64 bits version of AcessDatabaseEngine.
On the other hand, I have SQL Server Management Studio 17.2, 64 bits also, but, when I try to import an xlsx file with the Import Wizard, it shows the error "'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".
If I uninstall 64 bits of AcessDatabaseEngine and install 32 bits version, SQL Server Management Studio works, but my application stops working.
The most curious thing, is that this worked before. I could use both SQL Server Management Studio and my application at the same time. Suddenly, SSMS stopped working.
Other fact is: even when I installed 64 bits version of SSMS, it was actually installed in "Program Files (x86)". I think this is the cause, so the question is, how can I solve this problem without the need to uninstall and install Access Engine components every time I use one application or the other?
Best regards,
Jaime
2 Reset to default
