Record locking error when adding a record

[Guest]

I have a Multi User database with a FE and BE on a shared drive. There are 2 or 3 users working at the same time and whenever any of us add a new record and start to enter the information in the first filed a dialog box pops up saying "Field cannot be updated" When I click OK , it then let's me edit the record. When I click on help it tells me that its error "3164" and "You tried to update a field in a record or table that is currently locked by another user. Wait for the other user to finish working with the record or table, and then try the operation again. " Any Ideas on how this could be addressed would be great

 

[Pieter Wijnen]

this is probably due to the fact that Access (at least older versions)
implement data block locks (a 2K) instead of row locks
There are several ways to resolve
1) make the recordssize near 2K
2) Catch the error & retry save x number of times (using timer)
3) make the edit form unbound (fetch the data & use a Query/recordset to
insert/update)
4) discard a new entry if not saved within a time limit (combine with 1))
5) Use a "real" SQL Daytabase as a backend (oracle/sqlserver)

These are the soulutions that readily spring to mind

HTH

Pieter

I have a Multi User database with a FE and BE on a shared drive. There

are 2 or 3 users working at the same time and whenever any of us add a new
record and start to enter the information in the first filed a dialog box
pops up saying "Field cannot be updated" When I click OK , it then let's me
edit the record. When I click on help it tells me that its error "3164" and
"You tried to update a field in a record or table that is currently locked
by another user. Wait for the other user to finish working with the record
or table, and then try the operation again. " Any Ideas on how this could
be addressed would be great