View original (French)

Error message: MaxLocksPerFile

ChBro Posted messages 17 Status Member -  
 chrisroll -
When running a request under Access 2000 the following message appears:

The number of locks available for file sharing has been exceeded. Increase the registry entry MaxLocksPerFile

Okay to modify but up to what value can we go?
And what are the drawbacks?

Additionally there are 3 MaxLocksPerFile keys... ?
Thanks for the solution provided

3 answers

  1. florian
     
    i found this at the following address:

    http://support.microsoft.com/kb/q198633/

    there are a few warnings that are worth reading before doing the operation.

    1. Quit Microsoft Access.
    2. Click Start and then click Run.
    3. In the Open box, type regedit.
    4. Locate the Regedit HKEY_LOCAL_MACHINE folder.
    5. Expand HKEY_LOCAL_MACHINE until you locate the folder SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0.
    6. Click the Jet 4.0 folder to display its contents.
    7. Select the MaxLocksPerFile entry; from the Edit menu, click Modify.
    8. In the DWORD Value Edit box, select Decimal and increase the number in the Value data field.
    9. Click OK to save the MaxLocksPerFile setting.
    10. Quit the Registry Editor.
    11. Start Microsoft Access and synchronize the replicas.
    10
    1. chrisroll
       
      Thank youuuuuuuuuuu it’s amazing!!!
      0
  3. harmakhis
     
    THANK YOU VERY MUCH GUYS ... that's why I love the internet every day
    0