J
James Franklin
Hi,
I have an Access 2000 Front-End/Back-End app which has a piece of code in it
which when run cycles through a large number of records within a table on
the backend, making changes to many of them.
When the code runs however, I get error 3052: "File Sharing Lock Count
Exceeded. Increase MaxLocksPerFile registry entry."
I have done this, following MS Knowledge Base article
http://support.microsoft.com/default.aspx?scid=kb;en-us;815281#kb5
However can anyone tell me:
1) Can I increase this setting to any value?
2) What are the disadvantages of doing so?
3) Should this be done on the FrontEnd or BackEnd pc?
4) Is there any way of avoiding this problem, other than changing the
registry setting?
5) What actually causes this problem.
Many thanks to anyone who can help with any of the above!
Jim F.
I have an Access 2000 Front-End/Back-End app which has a piece of code in it
which when run cycles through a large number of records within a table on
the backend, making changes to many of them.
When the code runs however, I get error 3052: "File Sharing Lock Count
Exceeded. Increase MaxLocksPerFile registry entry."
I have done this, following MS Knowledge Base article
http://support.microsoft.com/default.aspx?scid=kb;en-us;815281#kb5
However can anyone tell me:
1) Can I increase this setting to any value?
2) What are the disadvantages of doing so?
3) Should this be done on the FrontEnd or BackEnd pc?
4) Is there any way of avoiding this problem, other than changing the
registry setting?
5) What actually causes this problem.
Many thanks to anyone who can help with any of the above!
Jim F.