Hi Marian,
I just checked a new laptop PC that I have, which has the Vista Ultimate
operating system. This PC also has Office 2007 Ultimate installed on it. This
key is present in the location shown in KB
http://support.microsoft.com/?id=815281.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
I'm not sure why your machine seems to be missing it. I would just go ahead
and add it. Here is a copy of what this branch looks like, when I exported it
from my registry (I changed the MaxLocksPerFile setting first, from the
default value of 9500 to 200000):
==================================
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0]
"PageTimeout"=dword:00001388
"LockRetry"=dword:00000014
"MaxBufferSize"=dword:00000000
"Threads"=dword:00000003
"ExclusiveAsyncDelay"=dword:000007d0
"SharedAsyncDelay"=dword:00000032
"FlushTransactionTimeout"=dword:000001f4
"MaxLocksPerFile"=dword:00030d40
"LockDelay"=dword:00000064
"RecycleLVs"=dword:00000000
"PagesLockedToTableLock"=dword:00000000
"UserCommitSync"="yes"
"ImplicitCommitSync"="no"
==================================
You can open NotePad, copy the above and paste into a new text file. Save
the file with the .reg file extension. Then double-click it.
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________
"Marian M." wrote:
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