File sharing lock count exceeded. (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 hit this threshold include the following:

• Amount of available memory
  
  
• Size of rows in the recordset
  
  
• Network operating system restrictions