The 'Microsoft.ACE.OLEDB.14.0' provider is not registered .....

My computer buggered up and so I am having to use Access 2010 and VB.Net Express. I have downloaded the Database Connectivity files, but I am still getting the above. Any ideas?

Although this is not the exact answer you are looking for, it may lead you in the right direction. I googled your error message and this is what returned. You may wish to check the MicroSoft site and knowledge base.

http://ellisweb.net/2010/01/connecting-to-excel-and-access-files-using-net-on-a-64-bit-server/

Alan

Thank you for giving it a try. That is exactly what I have been doing. It is very frustrating. That is always the problem with new tech.

P

I installed the 64 bit version of release 14.0 beta of the MicrosoftDatabaseEngine and had the same error. I checked the install log and found ACEOLEDB.DLL to be the implementing .dll. After checking the registery, I found that this .dll was registered as the Microsoft.ACE.OleDb.12.0 provider, not the Microsoft.ACE.OleDb.14.0 provider as documented. Rechecking the install log confirmed that this had been installed under the older version number.

I retried my application using "Microsoft.ACE.OleDb.12.0" as the provider and it worked.

I expect the released version of this driver will use the correct version number. In the meantime, using "Microsoft.ACE.OleDb.12.0" as the provider will keeping you going.