File locks

[Bdavis]

While performing certain operations I get an error which
says "File Sharing lock count exceeded. Increase
MaxLockPerFile registry entry."

What does this mean and how do I fix it?

Thanks

 

[Arvin Meyer]

While performing certain operations I get an error which
says "File Sharing lock count exceeded. Increase
MaxLockPerFile registry entry."

What does this mean and how do I fix it?

BTW, it's not MaxLockPerFile, its MaxLocksPerFile with an "S". It means
they're set to low for what you are doing. You have not told us which
version of Access/JET you're using, nor what you are doing that causes this
error. Unfortunately, there's no way to fix it without altering the
registry. You may have to do it on the server too, so be prepared to have
the network administrator break your arms and legs before he'll let you mess
with his servers without knowing exactly what and more importantly why.
Here's the what:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet
4.0\MaxLocksPerFile

It's set at 9500 by default, I'd raise it temporarily, then set it back to
where it was. Just remember that the Registry is a place where "only guru's
and fools go".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[bdavis]

Thanks,

I'm using Access 2000. The error occurrs doing simple
things like find and replace or changing field types.
I've found work arounds but it be nice to fix the issue.
I'll prepare for my leg breaking in the mean-time.