could not update; currently locked

J

Jason

I have created a database in Access 2000 that is shared
between eight users, which worked great for a while. I a
now having problems in that when a user wants to add a
new record, the database freezes and an error message
appears "could not update; currently locked". The user
then needs to close the database down and reopen it. This
is happening several times a day, and is causing
problems. I've tried compact and repair, I've upgraded to
Access 2003 and converted the database to that format,
and I've even archived the database, copied it's
structure and started again with new records, but to no
avail. Is this something to do with the locking strategy,
(which I've left as the default)? If so, can anyone
recommend a better strategy to use in the user
environment that I have described? Thanks for any help.
 
Top