Originally posted by: joshjulien
When creating a new database within Assisi, the code behind throws an unhandled exception.
System.Exception: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
The database is still created but not all of the data is removed.
Thoughts?
1 View
Originally posted by: Rich Howard
MaxLocksPerFile is a registry entry that limits the number of file system locks on the Access database file. It has been set at 9500 since its debut 2 decades ago but today it needs and can be set much higher. I routinely set it at 100,000 by running reg edit and searching for "MaxLocksPerFile". The Assisi setup wont do this for you because security and best practice is to not fool with other registry entries than the ones the setup creates.So, just run regedit, search for "MaxLocksPerFile" and change its value to 100,000. Regedit will show values in hex so us 100,000 in hex. Continue to search and change until all "MaxLocksPerFile" are set to 100,000. There can be many, like over 5 or so.