Preventing two users from Accessing the same Record

[durdle]

Hey,

I have a question regarding mutiple users accessing the same table, in particular the same record. I was wondering is there a way to prevent this from happening, a way to "lock" a record if it is currently used. This database has 20 user ID's in it, so if one user is updating the record, noone else can retrieve it.
Any input would be great

Thanks

Chris
________
ford model 91

 

[Maritza]

From your Tool Menu options, Select Options, Select the Advanced Tab. On the right side of that TAB you will see an Option that has "Default Record Locking", select "Edited Record", that should work.