Corrupted File / Database

[jennilein]

Hi..

When trying to open most tables and/or reports in a database designed by someone else, I get the error 'file may be corrupted create back up and then compact and repair'. The problem is it won't even let me compact and repair. Also, when trying to open certain tables, the 'corruption error' gets caught in a loop and access can only be exited with ctrl-alt-delete.

Any urgent help would be appreciated!

 

[Remou]

This may help:

http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Sometimes it is possible to get data out of a corrupt database with ADO.

It is pretty nearly always best to split databases, it helps to avoid corruption and makes recovery easier.

 

[jennilein]

Thanks for the tip, but even the first step of trying to import the tables one by one into a new mdb doesn't work. Any other suggestions?

 

[Remou]

Are you saying that you cannot import definitions only? In a copy of the database, can you locate the region where the corruption is occurring? Which version of Access are you using?