MaxLocksPerFile exceeded

  • Thread starter Thread starter Ray S.
  • Start date Start date
R

Ray S.

I tried to use the table analyzer in MS Access to see what it does. When I
got to the end it couldn't create a query and gave me the above error. I went
to the registry editor and found that the setting was 9500. I am working on a
Novell network and read that I can't increase the locks beyond 10,000.
Anyway, that sounds like a lot. My original test table has nearly 37,000
records.
 
Back
Top