Currently Locked by user

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I am getting the error above in a multiuser access 97
database, when users are adding or deleting records. I
have the form set so that a user can only see his/her own
records. The record lock is set to Edited Record. The
refresh interval is set to 1 second.

Any suggestions?

Thanks
 
Is your database opened as a whole by each user or is your database split
into the recommended Backend/Frontend for network sharing? If it is the
former, then this is your problem. Although you are filtering each user's
records, a lock is being placed on the whole database.
 
Back
Top