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.