3052: File sharing lock count exceeded

Published: March 28, 2005


Last Updated: 2009-12-07

Applies To


When opening Guard1 Plus


When attempting to edit or delete a Button or Facilities Tab item


When attempting to Archive or Backup the Guard1 Plus database


You receive the following error:



The following errors are related and may precede or follow the 3052 error:


The Guard1 Plus database is too large. As the Guard1 Plus database grows, changes to the database require more records to be accessed per action than the default MS Access MaxLocksPerFile setting can accommodate. If the number of records accessed exceeds the default MaxLocksPerFile setting, the error is returned.



Important: This article contains information about modifying the Windows Registry. Before you modify the Registry, make sure to back it up and make sure that you understand how to restore the Registry if a problem occurs. For information about how to back up, restore, and edit the Registry, click the following article number to view the article in the Microsoft Knowledge Base:


KB256986 (http://support.microsoft.com/kb/256986/) Description of the Microsoft Windows Registry


You must be an Administrator to edit the Windows Registry. If you do not have Administrator privileges, or are not familiar with the terms and methods described in the procedure below, please contact your IT Department for assistance.


Increase the MaxLocksPerFile setting:

  1. Close all open programs.
  2. Click Start > Run(XP) or click Start, then click in the Search box (Vista or 7).
  3. Type regedit then press Enter. This will open Registry Editor.
  4. On the left side of the screen, navigate to the folder HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0.
  5. Click on the Jet 4.0 folder to view its contents.
  6. In the right window pane, double-click the MaxLocksPerFile entry.
  7. In the Edit DWORD Value dialog box, select Decimal and increase the number in the Value Data box to 300000.
  8.  Click OK.
  9. Close Registry Editor.
  10. Reboot the PC.
  11. Restart Guard1 Plus and attempt the action that caused the error.


If the error does not recur it is highly recommended that you Archive your database immediately to reduce its size. If the database grows too large it may become corrupt, resulting in loss of all your button and patrol data. Corrupt databases are not recoverable.


If the error recurs you must reduce the size of the Guard1 Plus database.


See Guard1 Plus Data Maintenance for information on how to prevent database problems.














Copyright © TimeKeeping Systems, Inc.