Access 2000 error: Could not update currently locked

We have a nice Access 2000 database, residing on a nice fast server, used by
six users on Windows 2000 and Windows XP workstations. About twice a day we
get the error "Could not update currently locked", and the only fix is for
everyone to exit from the database; then we can restart it and it works OK.

The users haven't been able to spot any trends or offer any clues about when
or why it happens.

Can anyone offer any suggestions about what might be causing this, or how I
can go about troubleshooting it? Thanks!
.

Relevant Pages

  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)
  • RE: 2nd form with recordset of 1st
    ... processes using this table using optimistic locking? ... If this is a split database, is there a persistent connection to the back ... Every directory traversed requires Windows to ... > record source to be the 1st forms recordset? ...
    (microsoft.public.access.formscoding)
  • Re: OID/LDAP problem - Any help with a fix would be appreciated
    ... Make sure the windows workstation has SQLNET.ORA ... Hard error on read, ... The database "hang" only occurs when database links are used. ...
    (comp.databases.oracle.server)