Error when opening

[J]

A friend's laptop battery went dead when a database was open and now the
following error is appearing when they try to open the db:

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

This is a single user database and unfortunately is not split between a
front end/back end. Any ideas on how I can at least get to the data in the
tables??

The db was designed in Access 2003.

Thanks!

 

[Dirk Goldgar]

A friend's laptop battery went dead when a database was open and now the
following error is appearing when they try to open the db:

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

This is a single user database and unfortunately is not split between a
front end/back end. Any ideas on how I can at least get to the data in
the
tables??

The db was designed in Access 2003.

I'm not sure, but try this: with the database *closed* and Access closed,
look in the folder where the .mdb file lives for a matching .ldb file --
that is, a file with the same name as the database but with the ".ldb"
extension. If you don't find one, then this isn't the source of your
problem. If you do find one, delete it. If the operating system won't let
you delete it, reboot the computer and then delete it.

Having done that, open the database and see if it behaves normally. If it
still doesn't work, it's likely that the database file was corrupted. In
that case, you might try creating a new database and importing all the
tables and objects from the old database into the new one.

 

[J]

There is no ldb file.

I tried creating a blank db and importing the tables in, but I get the same
error when I go to import.

Any other ideas??

 

[Dirk Goldgar]

There is no ldb file.

I tried creating a blank db and importing the tables in, but I get the
same
error when I go to import.

Any other ideas??

Does it do this no matter what table you try to import? Can you import some
tables but not others?

Tony Toews has collected the best information I know of on corrupt MDBs.
Here's his page:

http://www.granite.ab.ca/access/corruptmdbs.htm

If all else fails, you may have to resort to a backup. If there's no backup
or it's not good enough, you may have to consult with a repair company.
Tony also has a list of repair companies on the above page.