Using access's default locking mechanism the user is not alerted that someone else has the record open until after they make all the changes and then hit save. It wastes their time to find out at the end. If you check when the record becomes active and alert them it is already open by another...
I have a form that multiple users will be using to view/edit records at the same time.
To prevent data from being edited by 2 people at the same time I am using the following method:
I have a table called Tracking that has the following fields
ID (primary key)
Lockstatus = 'Open' or 'Closed'...
