In a multi- user environment, several users could attempt to edit the same record simultaneously . Access prevents conflicts of this sort using record locking , ensuring that only one user at a time can edit data. You can also prevent conflicts by opening the database in exclusive mode , preventing all other users from accessing the database while you're using it. This technique is useful for administrators who need sole access to the system while making changes to the database itself.
Set Record Locking