File sharing lock count exceeded

Z

Zanne

I encountered this error when we synchronized a large database. Please give
me advice on how to solve the problem.

File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
(Error 3052)

You have exceeded the maximum number of locks allowed on a recordset. This
limit is specified by the MaxLocksPerFile setting in your system registry.
The default value is 9500, and can be changed either by editing the registry
with Regedit.exe or with the SetOption method.
Some other factors that may cause an application to reach this threshold
include the following:
• amount of available memory
• size of rows in the recordset
• network operating system restrictions
 
S

sherroc

Zanne,

I have experienced this same error message while trying to split a table with
tools - analyze - table menu item. Access just stops working and I have to
close it down.

Did you find a solution to the problem and if so what is it?

Thanks
Crystal
 

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

Top