MaxLocksPerFile

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chip_on - 05 May 2007 14:49 GMT

I have recently needed to increase the values in the MaxLocksPerFile entries
of my registry in order to get Access to run certain update queries. I have
a couple of questions about this entry.

What purpose does it serve?
How do I know how large to change the values?
Is there a point at which the size of this entry starts to degrade
performance?

Thanks for any help anyone can give.

Don

Reply to this Message

Dave Patrick - 06 May 2007 01:10 GMT

These articles may help or try asking in the Access groups.

http://www.google.com/search?hl=en&q=MaxLocksPerFile+site%3Amicrosoft.com

Signature

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

>I have recently needed to increase the values in the MaxLocksPerFile
>entries of my registry in order to get Access to run certain update
[quoted text clipped - 8 lines]
>
> Don

Reply to this Message