MaxLocksPerFile (File Sharing lock count exceeded)

D

david

HI,
I was trying to use Table Analyzer to split a table, and got this message:
File sharing lock count exceeded.
Increase MaxLocksPerFile registry entry.

I then edit the registry, found MaxLocksPerFile appearing at several places,
changed them all (from 9500 to something like 20,000, and later to 100,000).
And I still have the same error.
The error occurs when the wizard tries to create queries for the split tables.
Does anyone know about this ? Thanks.
David
 
D

david

QUESTION WITHDRAWN.
REBOOT FIX IT.
(Still I wonder what could have generated so many "file sharing locks"?)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

file sharing lock count exceeded 3
File sharing lock count exceeded. 1
Error on Alter Table to insert identity (counter) 0
Error 3052 MaxLocksPerFile exceeded 2
File sharing lock count exceeded 2
File sharing lock count exceeded. Increase MaxLocksPerFile registry 4
Receiving File sharing lock count exceeded in Access 2007 4
maxlocksperfile 1

Top