Access 2007 database error

ErvinNemes · 8 Dec 2015 at 14:54

I have just received the following error message:
Microsoft access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database.
The names of the objects recovered will be logged in the "Recovery Errors" table.
When I click ok I the get:
The database 'C:\Documents\Users\bryanscott53\documents\test.mdb' can't be repaired or isn't a Microsoft Access database file.
Unfortunately the same for the back up copy too....
Any suggestions on how to fix would be appreciated.

andshrew · 8 Dec 2015 at 15:44

Take a look at Microsoft's troubleshooting guide.

Armageus · 8 Dec 2015 at 15:49

Run JetComp against the database and recover to a new file. Tends to fix most issues (including "Unrecognised Database Format Errors").

https://support.microsoft.com/EN-US/kb/295334

HyperSonic · 10 Dec 2015 at 12:52

Could try opening the .mdb with the /decompile flag. It can recover some corrupt databases.

Or as Armageus says, recover all of the database contents to a new database using either JetComp, or by hand using a blank database and importing all of the elements from the corrupt database into it.

Matt_Hirst · 11 Dec 2015 at 15:31

Is there a space in the extension filename or have you mistyped it?

The database 'C:\Documents\Users\bryanscott53\documents\test.md b'

Matt

andshrew · 11 Dec 2015 at 19:26

Matt_Hirst said:
Is there a space in the extension filename or have you mistyped it?

The database 'C:\Documents\Users\bryanscott53\documents\test.md b'

Matt

I think the forum splits strings over a certain length.

eustacetodd · 12 Dec 2015 at 14:55

Whatever you do to try to resolve this make sure you do it on COPY of the file.
I would that you try a Decompile and see if that gets you any further.
Use a Run command from the Windows console: for example..
C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe "C:\databases\northwind2.accdb" /decompile
You can also try importing all objects into a new database. I would be inclined to do all tables first and see if that's OK and then get the forms and see if that's OK and so on.
Then if you have a problem you may have to import objects one-by-one until you identify the one(s) that cause the proble an by-pass those objects.
If you thus fail to solve the problem then try Access Recovery Toolbox utility. This is also a good tool. If this does not help to recover the database, then try to consult a specialist. Maybe this will help. http://www.oemailrecovery.com/access_recovery.html

eustacetodd · 12 Dec 2015 at 14:57

Check out this...
https://support.microsoft.com/en-us/kb/283849
http://www.fixya.com/support/t25470432-access_database_2003_problem_copy

ErvinNemes · 14 Dec 2015 at 12:59

Thank you all guys for your advice! The issue has been resolved.

gpuerrilla · 3 Jan 2016 at 19:36

What was the method that worked?