Locking Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

- Access 2002
- Typical front end mdb linked to backend mdb on network server
- Application is a call center staffed by 6 people and they routinely add
records
from the phone calls they receive.
- The front end mdb is essentialy one main form that adds records to the
CallRecv
table located in the back end mdb. The primary key of the CallRecv
table has the
data type of AutoNumber

Problem: Sometimes, not always, when the main form opens on startup and a
user attempts to enter data in a text box, this message appears:

"Could not update; currently locked."

When this happens to one user, it happens to all users.

Anybody have any ideas of what's going on?
 
In a multi-user environment you should think about what you want to do if
your users are trying to update data in the same table at the same time. Have
a look at Access help on Locking - it's pretty good. In the case you describe
I'd try setting the default locking startegy to No locks in
Tools->Options->Advanced - then if there is a conflict the user will be
notified and have the option to backout there changes, write a previous users
changes or reselect.
 
It's set to 'No Locks' now and I'm going to change it to either 'All records'
or 'Edited record' just to try something different.
 
Back
Top