Retrieve Tables from Corrupt Database

[Guest]

When trying to open a database I'm getting the following error:

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

There is no one currently in the database. All I want to do is try to get to
the 4 tables in the database and re-insert them into another working
database. If I try to compact and repair the database using a vba macro it
errors out, and the JetComp tool on the Microsoft Internet didn't work
either. If I try to simply import the tables into another database I get the
same error message. Is there any way to retrieve the tables in the Access
database or am I out of luck?

Thanks!!

 

[Allen Browne]

First thing to try would be to close the database, and see if there is an
ldb file in the same folder as your mdb. The ldb contains locking
info--spurious locking info after a crash--so delete it.

If that does not solve the problem, see:
How to recover data from a damaged database table or a corrupted
database table
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;247771