Are you using the Front-End / Back-End split system or just a single
database file?
Check the RecordLocks Property of the Form and make sure it is not set to
"All Records".
--
HTH
Van T. Dinh
MVP (Access)
"Paul" wrote in message
...
I have a multiuser database based around 2 main tables -
TblMaster and TblSub. They are linked with a one
(TblMaster) to many (TblSub) relationship. Now, when
someone enters data into the TblMaster fields and then
tries to enter any data, either from a combo box or into a
blank field, into the subform the database freezes and
about 10 seconds later an error dialogue box pops up
saying "Could not update; currently locked".
Can anyone shed any light on what is causing this and how
to rectifiy it?
Thanks,
|