How can you check if another user has the record locked?

G

Guest

I have a somewhat simple database split to a front end and a back end.
Everything works well for 99.9999% of the time . However, every now and them
someone wants to update the same record that someone else has locked. How
can I tell if another user has the record locked BEFORE they attempt to edit
it?
 
M

Michel Walsh

Hi,


Have your code trying to edit a field BEFORE the end user has time to
try the same from the user interface? You code should be able to catch an
impossible edit with error handling.


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

Error: Argument Not Optional 0
How can I explicitly lock a certain record? 1
By Code, Is A record being Edited by another user 4
Can I tell who has a record locked? 2
Reading a field when field is locked? 13
Unlock text box for new record entry 5
setting 'tag' properties to locked fo every record 2
Record Locked Dialog Box 2

Top