How do I identify the record that is locked?

[Guest]

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.

 

[Guest]

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

 

[Joseph Meehan]

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.

Depending on the version of Access, it may not be a single record as
some versions lock pages, not just records and a page can contain more than
one record.