Fix File sharing lock count exceeded error in Office Access

Download PC Repair Tool to quickly detect & fix Windows errors automatically

In Windows, in that location is a sure limit for sharing files concurrently. If this threshold limit is exceeded, the fail sharing operation cannot exist performed and you take to give it some other try. There is a registry element that monitors and takes care of the maximum file sharing limit and it's chosen MaxLocksPerFile entry. So when the file-sharing limit is reached, you will receive the post-obit mistake:

File sharing lock count exceeded, Increase MaxLocksPerFile registry entry

We got this error while sharing business organisation files via Microsoft Access. There is a large possibility that you came around this result with Access specifically considering chances of exceeding file sharing capability remain with this application.

Sometimes a reboot of the system may help yous to overcome this event while in some cases you demand to follow the mandatory steps to increase MaxLocksPerFile registry value as per the suggestion of the mistake bulletin.

Hither is how to increase MaxLocksPerFile registry value:

These steps will involve registry manipulation. Making mistakes while manipulating the registry could bear upon your system adversely. And then be careful while editing registry entries and create a System Restore point first.

1. Press Windows Key + R combination, blazon put regedit in the Run dialog box and hit Enter to open the Registry Editor.

2. Navigate here:

If you're 32-bit Windows edition:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Role\x.0\Access Connectivity Engine\Engines\ACE

If you're 64-flake Windows edition:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\x.0\Access Connectivity Engine\Engines\ACE

Substitute the placeholder x.0 with 16.0 for Outlook 2022, 15.0 for Outlook 2022, 14.0 for Outlook 2022, 12.0 for Outlook 2007, xi.0 for Outlook 2003, etc.

iii. In the right pane of this registry location, expect for the MaxLocksPerFile named registry DWORD (REG_DWORD) whose default value is the root crusade of this problem. The default value is 9500 in the decimal base of operations, so double click on the same DWORD to get this:

iv. In the Edit DWORD Value box shown above, increase the Value data from the default value as per your need, for case, set it to 15000. Make certain that the selected base is Decimal. Click OK. Close Registry Editor and restart Windows/File Explorer to make changes effective.

Now try sharing files concurrently, and yous won't have whatsoever problems.

Read: File Sharing is non working in Windows.

Let us know if this helps you!

An Electrical Engineer by profession, Kapil is a Microsoft MVP and a Microsoft Content Creator. Please read the entire post & the comments first & create a system restore point before making whatever changes to your system.