Error while opening file

[Idris]

Dear friends

Please help

I have an Financial application - with lots of transactions approx 92000 records linked in then 37 tables - yesterday while opening the file I get this message (attached) and am unable to reopen the file.

Please advice ASAP.

Thanking you in anticipation for the considering the request.

 

[ghudson]

Your db is corrupt. Make a copy of it before you attempt to fix it.

Try to import all of the db objects into a new db.

If that does not work... Search around for there are plenty of threads discussing the various ways to try and fix a sick db.

 

[Idris]

Thanks Ghudson

I have tried importing the table linking the tables to new .mdb file - but doesnt work. The moment it opens it gives me the same message.

I have the backup copy but the few days work will be a lost - but still to work around for future mishape - what would you recommend?