"MaxLocksPerFile" Error

[Conan Kelly]

Hello all,

I recieved this error, looked it up in the help files, found the item I need to change in Registry Editor.

The question is how do I know which one I need to change, there are 3 options (the following is a REG file I came up with to revert
back to orig settings):



Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5]
"MaxLocksPerFile"=dword:0000251c

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x]
"MaxLocksPerFile"=dword:0000251c

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0]
"MaxLocksPerFile"=dword:0000251c



Also, How high do I need to set it? Just greater than the number of records in the table I'm changing? In the examples above, the
setting is 9500. So will this setting work for a table that has 9499 records in it AND blow up on a table that has 9501 records in
it? Follow my thinking? Am I thinking correctly?

Thanks for any help anyone can provide,

Conan Kelly

 

[Guest]

This should be able to assist you.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;815281