MS Access/accdb "Cannot open database" error (C#)

c# ms-access jet
Jdinklage Morgoone picture Jdinklage Morgoone · Dec 23, 2013 · Viewed 13.2k times · Source

I'm using an MS Access database to store data for a desktop application. This week I was asked to give access to the application to some additional users, but whenever they launch the application they are getting the error message:

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.

I have gone through 5 pages of Google search results trying to find a solution and come up with nothing. Every answer I can find to this problem is either the 2GB limit (which my db is nowhere near) or corruption (which is not the case because only two new users are receiving this error and everyone else is fine).

This is my connection string:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[Path];Jet OLEDB:Database Password=[Password];"

I'm pretty sure this is due to the users' machines missing something, but I cannot figure out what or where they can get it from. Please advise.

Answer

crthompson picture crthompson · Dec 23, 2013

Your connection string indicates that you are using the Microsoft.ACE.OLEDB.12.0 driver.

This must be installed on the machine, as it doesn't come with windows.

You can find the driver in the Microsoft Access Database Engine 2010 Redistributable

Related questions

How Can I Remove Access Db's temporary ldb file

I have an ASP.NET Project. I am connecting to the DB and then closing and disposing of the connection object. But when anyone enters my site, MS Access creates a temporary dbname.ldb. When I want to download my …

Read More
How can I get a list of tables in an Access (Jet) database?

I need to see if a table exists in an Access database used by my c# program. Is know there are SQL commands for other databases that will return a list of tables. Is there such a command for Access/…

Read More
How to determine Jet database Engine Type programmatically

I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn't already that version. (This enables use of SQL-92 syntax features) Upgrading is (relatively) easy. A call to the JRO.…

Read More