REJECTED: Solution #3 - Explicit Locking
Optionally specify that a table should be managed via Explicit Locking.
If set then dbFront would lock that record for all users but allow users to request an explicit lock if they wanted to edit a record.
If a lock was requested and granted then all other users would be prevented from editing that same record.
The risk that a user might lock a record and then step away would be relatively minimal.
I have decided to REJECT this idea because it would be too complicated and there did not appear to be any interest.