Form Locking

C

Carlee Grant

Hi there,

I have several forms in my database. When several users
tried to access 2 of them, only one person at a time was
allowed to make any changes to any of the data in the
table assoicated to the form. The form is based on a
query qryFormShipment. The record locking is set to
Edited Records. The Form lock is set to Edited Records.

Can anyone explain why i am getting a lock situation when
more than one user is accessing the form. I am running
Access 97.

Kind regards,
Carlee
 
Top