"Cannot open database. It may not be a database that your application recognizes or the file may be corrupt," works on one computer but not another

Question

I have written an application in VB.Net 2010 with an Access 2010 password protected database.  I have copied this application and its database to my other computers as I have upgraded in the past without any problems.

The Provider is defined as ""Provider=Microsoft.ACE.OLEDB.12.0;", and the Data Source is "Data Source=" + My.Settings.DataLoc + "\PassMan.accdb;Jet OLEDB:Database Password="MyPassword;"

This time I bought a new notebook and installed Office 2016 including Access 2016.  When I copied my application and database to the new notebook I have been getting the above error message even after installing the Access database engine 2007.

The database is small, less than 500k.  It's password is only 10 characters, only upper and lower case letters and numbers, no special characters.

I need this application to work on my notebook.  Any help?

Answer 1

>>even after installing the Access database engine 2007

Not sure if the above was a typo or not but if I was going to try anything, it would be to download and install the correct bit version of the Access 2010 DBEngine

Microsoft Access Database Engine 2010 Redistributable

https://www.microsoft.com/en-ca/download/detail...

The above is not suggesting that it will definitively will resolve your problem but at least it removes the Ace driver set as being the source of the problem.

Answer 2

Not a typo, the wrong file and the solution to my problem.  THANK YOU!

Answer 3

I suggest that you also post your question on the Microsoft TechNet forum. It has additional technical experts that may also help you.

https://social.technet.microsoft.com/Forums/en-...

If you post there, you will be posting on two forums and can get expert replies from both forums.