Releasing User Database Locks | Top Previous Next

Whenever User clicks Change button on any form in the application the corresponding record becomes locked and it is exclusively available for changes for the current User only. Other Users will be able to see the record but will not be able to modify it until the locking User either saves the changes or discards them by clicking Clear button on the form or Clear All button. If it takes too long for a User to modify the record and save the changes then the User lock may expire automatically. It happens after 10 minute timeout and can be controlled application-wide via LockTimeout System Property. However, there is a chance that User clicked Change button and acquired the exclusive record lock and after that either left the workstation or her internet connection was lost. In these cases other Users (or same User after reboot) have to wait for the lock to expire. On the Release Lock Form the System Administrator can find any current record locks and release them manually if needed.