"Sort_Probaddr->Error in sorting progaddr display order. File sharing lock count exceeded." message in PBFirst or PlanetPress

The error "PBFirst Error: Sort_Probaddr->Error in sorting progaddr display order. File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." occurs because number of locks required to perform a transaction exceeds the maximum number of locks per file.
Products affected: PB First™, PlanetPress®

Issue

The message "PBFirst Error: Sort_Probaddr->Error in sorting progaddr display order. File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." appears in PBFirst or PlanetPress.
pbf-sort-error_500x53

Cause

The number of locks required to perform a transaction has exceeded the maximum number of locks per file. The maximum number of locks per file is a default value set in Microsoft Windows.

Resolution

Important: This is a technical procedure that has the potential to cause problems if not done correctly. It is strongly recommended that you back up the registry before beginning. If you are not comfortable performing this procedure or do not have permission to do so, contact your IT department.

  1. Select Start > Run.
  2. Type regedit.
  3. Select OK.
  4. Locate the following registry key depending on your Access installation. Note: The <x.0> placeholder represents your version of Office (16.0 = Office 2016, Office 2019, Office LTSC 2021, or Microsoft 365, 15.0 = Office 2013).
    • Windows Installer (MSI) installation:
      • For 32-bit version of Access running on 32-bit version of Windows:
        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\<x.0>\Access Connectivity Engine\Engines\ACE
      • For 32-bit version of Access running on 64-bit version of Windows:
        HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\<x.0>\Access Connectivity Engine\Engines\ACE
    • Click-to-Run installation:
      • For 32-bit version of Access running on 32-bit version of Windows:
        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\<x.0>\Access Connectivity Engine\Engines\ACE
      • For 32-bit version of Access running on 64-bit version of Windows:
        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\<x.0>\Access Connectivity Engine\Engines\ACE
  5. Double click on MaxLocksPerFile to edit.
  6. Change base type to Decimal.
  7. Enter a very high number for Value data and select OK. The number needed may vary depending upon how many records you have, but we suggest starting with 100,000.

 

 

UPDATED: July 18, 2023