Show person locking/editing the record in the form with pessimistic lock?

  • Thread starter Cheng-Liang Shen
  • Start date
C

Cheng-Liang Shen

Hi All,

I have a record edit form with the pessimistic lock. How can I display the
current user locking the same record I am trying to edit?
Thanks.
 
M

Michel Walsh

Hi,

You can parse the error message to spot the user locking the record? I don't
remember the exact error message, but if memory serves, the "logon" name is
displayed ( probably Admin on another machine if you do not use User and
Group Security Level).


Hoping it may help,
Vanderghast, Access MVP
 

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

Similar Threads

Access Form - Lock Fields from Editing 0
How to know who is locking/editing the record in the record edit form? 1
pessimistic locking 3
record locking not behaving as expected 4
My data entry form.... isn't adding new data? 3
Find which user has record locked. 4
Listbox row source and record locking? 1
Lock only updated record 5

Top