3052 Error 3

[Toya2176]

Does anyone know what a runtime error 3052 - File Sharing count exceeded. Increase MaxLocksperFile registry entry means? This database works fine at home, but just recently at work it gives me this error and then halts. Does anyone know what I could do to correct this??

All help is appreciated.

 

[psemianonymous]

If your database is big, then you may actually need to do what it says: edit the registry. Start->Run: "regedit"

Search for "MaxLocksPerFile"

Up the number to a much larger number. Save, exit.



Alternately, I searched and found this answer:

An alternative to fixing the registry is:
dbengine.setoption dbMaxLocksPerFile, <SomeNumber>



There are other causes for this problem. Check Google Groups for threads similar to this one:

http://groups.google.com/groups?hl=...ksperfile&meta=group=comp.databases.ms-access

--
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

 

[Toya2176]

You are my hero. I really appreciate the help. That worked perfect.

 

[Isadore]

foolio: if you are still around thanks my friend!