View Single Post
  #3  
Old February 3rd, 2005, 01:58 AM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default

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,