could not update... currently locked

F

feetdontfailme

Does anyone know of a way to extract the username of the user causing the
locking in a multiple user environment of Access 2002 so that I could make a
custom error message like
msgbox "I'm sorry, but the record that you are
trying to update is currently being editted by user: " & strUser
Even a list of users trying to update the record causing the error would be
usefull
to me. Thank you in advance for your time and your responses.
 
Top