CODEWITHSUNDEEP
ms-access-2007ms-access-2010corruption
Shrout1
Shrout1

Reputation: 2607

Access database "Corrupt" in 2007; opens in 2010

I have an accdb database that is used by multiple individuals and stored on a network share. When opened in Acccess 2007 the following message appears:

Cannot open database "\\databasepath\filename.accdb". It may not be a database that your application recognizes or the file may be corrupt

Access 2010 opens the database with no problems.

What is the most common cause of this issue? I searched for database repair tools and can't find any Microsoft tools for accdb files (JetCompact didn't do it). I ran a compact and repair via Access 2010, did a save as locally and then copied it over to the share - no effect.

Other than magically upgrading all my users to Access 2010 (which won't happen) I'm in the dark here.

Upvotes: 1

Views: 1550

Answers (3)

Tom Collins
Tom Collins

Reputation: 4069

You may have some features you're using in 2010 that aren't supported in 2007.

Look here for more info.

Upvotes: 3

Aron Chappel
Aron Chappel

Reputation: 11

I would make a back-up, make another back-up and then first try importing all but the tables that contain attachments into a new database.

you can also check this: https://dba.stackexchange.com/questions/71906/ms-access-mdb-ldb-database-corrupted

Upvotes: 0

Bill M
Bill M

Reputation: 26

Most likely someone opened it in 2010, edited your report and saved the change. This will break 2007 every time. 2010 is NOT backwards compatible with 2007

Upvotes: 1

Related Questions