View Single Post
Old 09-23-2007   #10 (permalink)
Sascha Trowitzsch


 
 

Re: can't find HKey...soft\Jet in Vista registry; re MaxLocksPerFile

Hi,

Why should it be necessary to change the maxlocksperfile option in the registry?
You can set it temporarely via code like this:

DBEngine.SetOption dbMaxLocksPerFile, 200000

Ciao, Sascha

"Marian M." <MarianM@xxxxxx> schrieb im Newsbeitrag
news:646F9FA4-48AB-4F7C-A15C-F0C2B680DD84@xxxxxx
Quote:

> Is there a regedit way to change the file sharing lock count in Vista? The MS
> article 815281 must be giving directions for XP. I don't see
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0, or even
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet, in my machines registry. I'm
> nervous about using VBA to do this.
>
> TYIA
>
> Marian
>

My System SpecsSystem Spec