MaxLocksPerFile

Hi

I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.

I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.

i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.

Please help me to resolve this Issue.

-Regards
Harpreet

The default value for both Jet 3.5 and 4.0 is 9500.

If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.

The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.

See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.

|||

Hi Joel,

Thanx for your reply.

Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.

Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.

-Regards

Harpreet

|||

Here is a link to the book on Amazon:

http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9

The registry is:

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile

default is 9500

|||

Hi Joel

Thanks for the information.

Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.

-Regards

Harpreet

|||The registry value is created in setup or when registering msjet40.dll.|||

HI Joel,

Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.