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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top