Access database “Corrupt” in 2007; opens in 2010

Question

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.

Answer 1

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

Look here for more info.

Answer 2

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

Answer 3

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