Open Records - one at a time

  • Thread starter Thread starter Beeyen
  • Start date Start date
B

Beeyen

I would like to prevent a record from being updated by a user at the same
time. How can I enter code to prevent the same record in a form from being
updated by another user at the same time? The record can be opened multiply
times by different users but cannot be updated simultaneously. And if
someone opens the same record then tries to update a same record someone has
open and is updating, can I apply a popup message saying the record is
currently in use?

Thank you for any assistance you can provide.
 
Awesome Mr. Adams and Thank you! I will apply the option to Access 97
tomorrow.
And see if it works for the 30+ users that are still accessing the 97 DB. I
will let you know if it works

Thanks again
 

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

Going to first record 0
Access Automatically Send a notification email once a record is added 0
Prevent Navigating Past Last Record 2
How to check if record is Locked 1
DMax on existing record to increment serialized # fails 1
Separate Form 0
Help with form load 5
Hide/Skip Records that have "Edited Records" Record Lock 2

Back
Top