You read the title right, this is the exact question we got from one of our client. Most of the time non technical computer users, payroll officers to be exact will be surprised to have this kind of error popping up in their screen while processing their hard worked payroll.
File sharing lock thingy or File sharing lock count exceeded error with error number 3502 is actually a result when large chunk of data is being processed and the database reached its sharing limit. You see windows has certain limits for sharing files concurrently, Able Payroll and Able Bioplus both windows program and uses Microsoft access isn’t excluded in this kind of error.
This error can be easily fixed by modifying the registry. Below are easy simple steps but has to be done correctly in order to work
- Click on the start button and use the search box that says “Search Program and Files” to type “run” then press enter or in your keyboard press Windows Key + R. It should open a window like this.
- In that window type in regedit and press enter. It should open another window like this.
- Navigate to any of these path using the navigation pane at the left side.
- For 32 bit machines navigate on these
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0(any version number available)\Access Connectivity Engine\Engines\ACE
- For 64 bit machines navigate on these
- HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0
- HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0(any version number available)\Access Connectivity Engine\Engines\ACE
- In the right side of your Registry Editor, double click on MaxLocksPerFile. It should open a window like this.
- On the Base group box, select on Decimal then proceed on changing the Value Data to 15000 or higher depending on how big the chunk of data you need to process. Once done press enter and close any visible windows.
- We suggest to restart your computer to make sure that changes on the registry will be applied correctly.
Just a note, make sure that you follow the steps correctly and all of the programs that are using Microsoft access will be affected by this changes.