fix error 3197

[John]

I have data locked in a database and when I try to open
the database I get the message.
" 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 not true. I need to get the data out of the
records into another database. or fix this one. I tried
the jetcomp program. I get the same error message.

 

[Dirk Goldgar]

I have data locked in a database and when I try to open
the database I get the message.
" 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 not true. I need to get the data out of the
records into another database. or fix this one. I tried
the jetcomp program. I get the same error message.

If you are *certain* there is no one else in the database -- not someone
who maybe went away and left the database open on his computer -- then
try this:

Make sure you don't have the database open, and no one else does.

In the folder where the database is stored, look for an .ldb file with
the same name as the database. So if your database is named
"MyDatabase.mdb", look for a file named "MyDatabase.ldb". The File Type
may show as "Microsoft Access Record-Locking Information".

Try to delete that file. If the operating system won't let you delete
it, it may give you a message that tells you who has it locked, and you
can go hunt them down. If it will let you delete it, see if you can
then open the database.

If these steps don't work, it could be that your database is corrupted.
See Tony Toews' "Corrupt Microsoft Access MDBs FAQ" at
http://www.granite.ab.ca/access/corruptmdbs.htm .