Can someone explain briefly how multiuser access works in access. I have a database fe and be. The fe has forms and stuff. The thing is I do not want a user to be able to edit a record while another user is view it. Is this automatic or can I make it so?
Question Multiusers
- Thread starter Core
- Start date
Lightwave
Ad astra
- Local time
- Today, 13:35
- Joined
- Sep 27, 2004
- Messages
- 1,517
Provided you have a split database and a unique copy is located on the users machine access should take care of conflicts although it will be possible to potentially view a record while another is editing it. I'm not sure how you would alter this.
Off the top of my head you might be able to keep a yes no field in the table and whenever the record is being used set it to 1 and only allow users to view to records where that field is set to 0.
No experience of this though.
Off the top of my head you might be able to keep a yes no field in the table and whenever the record is being used set it to 1 and only allow users to view to records where that field is set to 0.
No experience of this though.
- Local time
- Today, 13:35
- Joined
- Sep 12, 2006
- Messages
- 16,072
I don't think so - the default is "no locks"
and is actually implemented as "optimisitc locking"
access detects if a record has been edited by another user, and stops you saving changes, as it would be unsafe.
I have never needed to implement any other record locking technique, and I suspect this would only be required in certain "transaction processing" environments.
most problems come down to design error - ie one user having the same record open twice - (ie 2 forms) which "simulates" a record update error.
