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