File sharing lock count exceeded

[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

 

[Arvin Meyer [MVP]]

Sounds like a Novell server. The last Novell server I administered was 8
years ago, but the locks were set in the autoexec, like:

(for 4.x servers)
SET MAXIMUM RECORD LOCKS PER CONNECTION=20000
SET MAXIMUM RECORD LOCKS = 400000
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[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