To remove locks generated by you, you need the 'Remove own locks' permission. To remove all existing locks, you need the 'Remove all locks' permission
Multiple users may gain simultaneous access to the same database. To protect data integrity, an automatic locking system is used to control the number of users allowed at one time to amend a given study definition or subject. Until the locks are removed, other users cannot access the same data.
Locks are removed automatically when the user has completed the action and exited from the study definition or subject. If there is a system or computer crash, however, locks sometimes remain in place which means that the user cannot access a study definition or a data entry form until the locks have been removed manually.
The Lock Administration option allows you to view and remove database locks. It is also available from the Study Definition, Data Entry and Data Review modules.
Warning: You must not remove a lock whilst the locked object is open otherwise data corruption can occur. Make quite sure that the object relating to the lock (e.g. study, subject, eForm) is no longer open or in use before removing its lock.
To remove locks generated by you, you need the 'Remove own locks' permission. To remove all existing locks, you need the 'Remove all locks' permission
Before removing a lock, make quite sure that the object relating to the lock is no longer open or in use.
Select Database > Lock Administration ... A popup window is displayed, listing the locks in the current database that you have permission to remove. For each lock you will see details of the object that is locked, the time that the lock was generated and the user name of the user who generated the lock.
Select the lock that you wish to remove and click Delete. You will be asked to confirm that you wish to remove that lock. Click Yes to remove it.
To refresh the list, click Refresh.
To close the window, click OK.