=========
QUESTION
———
When synchronizing in Microsoft Access, I get the following error:
ERROR: -2147467259 – File sharing lock count exceeded. Increase MaxLocksPerFile registry Entry.

 

=========
ANSWER
———
Adjust the registry entry MaxLocksPerFile to increase the maximum number – see: http://support.microsoft.com/kb/815281 (Method 1)

Start button, Run
Type: RegEdit
Click OK

For Access 2000, Access 2002, Access 2003 running on Windows 32 bit (x86)
Locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0

For Access 2000, Access 2002, Access 2003 running on Windows 64 bit (x64)
Locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0

For Access 2007 running on Windows 32 bit (x86)
Locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE

For Access 2007 running on Windows 64 bit (x64)
Locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE

For Access 2010 running on Windows 32 bit (x86)
Locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE

For Access 2010 running on Windows 64 bit (x64)
Locate the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE

In the right hand pane, double-click the MaxLocksPerFile item.
In the Edit DWORD Value window, select Decimal
Modify the number in the Value text field as required (perhaps up it by 4x?)

Click OK
Reboot

 

———
Or temporarily change the entry on a per database file basis by using SetOption in your VBA code – see: http://support.microsoft.com/kb/815281 (Method 2)

 

=========
EXAMPLES
———

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
Error
Sync

 

=========
REF
———
http://support.microsoft.com/kb/815281

 


http://www.anysitesupport.com/access-maxlocksperfile-file-sharing-lock-count-exceeded/
http://anySiteHosting.com