If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open Records - one at a time
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. |
#2
|
|||
|
|||
Open Records - one at a time
Goto Tools - Options - Advanced and under Default Record Locking select
Edited Record. It's now first come, first serve, so to speak! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#3
|
|||
|
|||
Open Records - one at a time
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 "Linq Adams via AccessMonster.com" wrote: Goto Tools - Options - Advanced and under Default Record Locking select Edited Record. It's now first come, first serve, so to speak! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#4
|
|||
|
|||
Open Records - one at a time
I can't swear that that option is available in v97, but it has been since
v2000. Good luck! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
Thread Tools | |
Display Modes | |
|
|