No record locks - but it says the record is locked....

Giganews Newsgroups
Subject: No record locks - but it says the record is locked....
Posted by:  musicloverlch (lhow…@gmail.com)
Date: Tue, 5 May 2020

Hi there!

I have a form with a subform in datasheet view (which I have done a million=
times) with the ability to add a new record. There are No Locks set on the=
main form or the subform. However when two people try to add a new record =
to the subform one of them gets the "Can't edit. Record is currently locked=
" message. Why can't they both add a new record at the same time? Why does =
the whole table lock up? This has never happened to me before.

Thanks,
Laura

Replies