A message appeared Increase MaxLocksPerFile

[toni3]

I tried to split my rather large table into related tables for a better running program, but the message I got said that "sharing lock count exceeded" and I needed to "Increase MaxLocksPerFile in the Registry Entry". Does anyone know what this is and where to increase it?

 

[psemianonymous]

I think this thread has exactly your problem (and the solution):

http://groups.google.com/groups?hl=...-access&meta=group%3Dcomp.databases.ms-access

Also helpful from this thread (

http://groups.google.com/groups?hl=...-access&meta=group%3Dcomp.databases.ms-access

):

From pages 669-670 of the Jet Database Engine Programmer's Guide:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5

From pages 612-614:

DBEngine.SetOption dbMaxLockPerFile, 20000



--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm