Data Entry/Review module

 

Removing database locks

MACRO is designed to allow several users simultaneous access to the same database. To protect data integrity, MACRO uses an automatic locking system which controls 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. This function is only available to those users who have been assigned the role of Administrator.

 

Locks are removed automatically when the user has completed the action and exited from the study definition or subject. But if there is a system error, locks can 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 Database Lock Administration option allows you to view and remove database locks. It is also available from the System Management and Study Definition modules. In the Data Entry/Review module, users are only able to remove their own locks.

 

You must close the current subject before you can access the menu option.

To remove locks

  1. Before removing a lock, ensure that you have closed the current subject and ensure that the object relating to the lock is no longer open or in use.

  2. Select Tools > Database Lock Administration.  A popup window lists 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 user name of the user who generated the lock and the time that the lock was generated.

  3. Select the lock that you wish to remove and click Delete Selected or click Delete All to remove all locks.

  4. Click OK to close the window.

 

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