Access 2010 Database - Multi Users - Same Record Prevention

[LisaEllen]

Hello,

I am the administrator for a 2010 Access Client Database that consists of many clients with their information and we have three users whom go in and edit-add information to this Database and it hasn't been a problem until two users have tried to edit the same client record at the same time and then we have had some issues...



So, not sure this is even possible, but can one prevent more than one user being on the same client record? Is there a way to have a message come and say this record is in use?

And, I don't know Code - just so you know...

Thank you for any help anyone can provide.

Lisa

[alansidman]

this link should help you remedy the situation
http://bytes.com/topic/access/answer...ng-same-record

Additionally if you google ms access prevent two users from editing the same record

there are lots of hits on how to deal with this issue.