Prevent multiple users accessing 1 record

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

RitchieJHicks

I would like to prevent more than 1 user viewing/ameding a record at any one
time. I would also like to display a friendly message if a user attempts to
access a record at the same time that someone is already in it.

Is there a simple way to do this, or is it not advisable?

Thanks,
Ritchie.
 
You can set the record locks to EDITED RECORD in the form you want this to
happen. I'm not sure you can give them a message though. The second user
into the record will see a symbol (black circle with line through it) next to
the record to show them that they cannot edit it as someone else has it open.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________
 
Back
Top