Tuesday, July 10, 2007

File Sharing Lock Count Exceeded

When processing large transactions within a Microsoft 'split-database' application, you may receive the above error.  The MS 'split-db' in Access is not a true client-server solution, it is a file-server solution that can lead to this error/issue.

To avoid this issue you need to manually change a registry setting for MS Jet 4.0.  Set the value to at least 1,000,000,000 and follow the Method 1 instructions linked to here:  http://support.microsoft.com/kb/815281

Post a Comment