 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006What's max limit for MAXLOCKSPERFILE in registry?
I keep getting error when trying to add a new autonumbered field to files with >50,000 records. Error messages suggests changing the MAXLOCKSPERFILE setting in registry. How much more than its default 9500 can I go? Is it affected by RAM? It is affected by RAM, I think it is a 32 bit integer value, on a modern machine you will probably hit the Jet Cache memory limit before you hit the MAXLOCKSPERFILE memory limit. (david) > I keep getting error when trying to add a new autonumbered field to files > with >50,000 records. Error messages suggests changing the MAXLOCKSPERFILE > setting in registry. How much more than its default 9500 can I go? Is it > affected by RAM? What's the Jet Cache memory limit on a PC with 1GB PC4000 memory? How does one find this value on his/her machine? > It is affected by RAM, I think it is a 32 bit integer value, on a modern > machine you will probably hit the Jet Cache memory limit before you hit the [quoted text clipped - 7 lines] > > setting in registry. How much more than its default 9500 can I go? Is it > > affected by RAM? 1) just change the locks: if you run out of cache you will get an error, if not, why worry? 2) look at help for DAO SetOption to find more on jet engine options 3) max cache is something like 13.5MB unless you set a specific value, then it runs out at about 250 MB. If you have 1GB, that still leaves 750 MB for locks, so I don't expect any locks you use will fill up memory. (david) > What's the Jet Cache memory limit on a PC with 1GB PC4000 memory? How does > one find this value on his/her machine? [quoted text clipped - 10 lines] > > > setting in registry. How much more than its default 9500 can I go? Is it > > > affected by RAM? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.