When performing a calculation, the following error may be displayed:
"File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."
The MaxLocksPerFile registry setting is too low. MaxLocksPerFile is a Microsoft Jet registry setting that is set to 9500 by default. A test with the default value for this setting allows the calculation of 139,000 selected records in Microsoft Access.
Use the Advanced ArcMap Settings utility to increase the MaxLocksPerFile value. This utility allows modifying the registry settings used by ArcGIS.
Note: This utility has a slightly different look depending on the version of ArcGIS.