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.
"Allie" wrote in message
...
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