Applies to: Office Therapy Standard, V7.59 and earlier
Problem
When entering numerous transactions (charges and payments), an error will occur stating 'Can't Lock File'. This is followed by another error causing the application to close or requiring the user to close the application.
Cause
The cause of this problem appears to be the number of available locks when reading from and updating the database. Each time there is a transaction reading from the database of updating it, records in the database are locked to handle potential conflicts if other users are trying to access those records. Normally, the locks are released when there is no activity. However, if there is no inactivity, the locks build and reach their defined limit.
Solution
The default limit of maximum locks is normally set to 9500 in the Windows Registry. This value can be increased to prevent or reduce the occurance of this issue.
You can contact DocuTrac Technical Support to make this change for you.
If you decide to make this registry change yourself, it is highly advisable to make a backup of the registry. The Registry Editor is an advanced tool for viewing and changing settings in your system registry, which contains information about how your computer runs. Follow the instructions in this document carefully. Incorrectly editing the registry may damage your system.
To change the setting, open the Windows Registry by clicking the Windows Start button and entering regedit.exe, and clicking it to run it.
- Select Find from the Edit menu.
- Enter MaxLocksPerFile and click Find Next
- Locate the registry key for MaxLocksPerFile for Jet 3.x
- Select the Key and double-click to modify it
- Change the type from hexidecimal to decimal
- Enter 20000 and click Ok
- Select File...Exit to close the Registry
You can increase the value if you find that you are still receiving the error. You can try to increase it in increments of 10000.
