How do I identify the record that is locked?

M

Martin

Below is the help on the error I'm receiving.

This is happening in a MDE. How do I either idenify the locked record or
get the data from the MDE to a MDB without the error?

The catch is that I'm not trying to update...

The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time. (Error
3197)
This error can occur in a multiuser environment.

Another user has changed the data you are trying to update. This error can
occur when multiple users open a table or create a Recordset and use
optimistic locking. Between the time you used the Edit method and the Update
method, another user changed the same data.

To overwrite the other user's changes with your own, execute the Update
method again.
 
G

Gav

I dont think you can identify the specific record (may be wrong though).
However.......there should be a file with extension '.ldb' in the same
directopry as your database.

if you open this it should allow you to see who else has the database open.
Simply ask them to come out it wjile you update or do what you have to do.

HTH

Gavin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top