Table locking Issue

[Guest]

I have a database that has up to 30 users updating a table
consistently throughout the day. The table locks up
multiple times during the day. Why does this happens and
what can I do to avoid the table locking?

 

[Duane Hookom]

You could program unbound forms with code to update records.
One issue that I always look at is normalization. A properly normalized
table will reduce the issues of record locking since each related table
might be updated by only one user at a time.