[AccessD] Who is locking the record?

Hi All,

In a multi-user split database using Access security, using the statement

Currentdb.Execute SQLUpdateQueryName, dbFailOnError

When it generates the error 3218 that a record is locked, how can I find out
which user is locking that record?

Is there a better way to do this?  What I want to do is know that the
operation failed and let the user know which other user they need to go to
and ask them to close a screen, or whatever.

Thanks in advance,

Jennifer