Re: What's max limit for MAXLOCKSPERFILE in registry?
- From: <david@epsomdotcomdotau>
- Date: Tue, 18 Jul 2006 09:27:15 +1000
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)
"PDIHAL" <PDIHAL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CBC66C5-08F2-4283-B5C5-8C76E85B7269@xxxxxxxxxxxxxxxx
What's the Jet Cache memory limit on a PC with 1GB PC4000 memory? How doesthe
one find this value on his/her machine?
"david@epsomdotcomdotau" wrote:
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
filesMAXLOCKSPERFILE memory limit.
(david)
"PDIHAL" <PDIHAL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:27757BB7-3A0B-43A8-BC56-709EF071B840@xxxxxxxxxxxxxxxx
I keep getting error when trying to add a new autonumbered field to
itwith >50,000 records. Error messages suggests changing theMAXLOCKSPERFILE
setting in registry. How much more than its default 9500 can I go? Is
affected by RAM?
.
- References:
- Prev by Date: Re: Form variable in query
- Next by Date: IIF statement in query criteria to have "Like "*" or Is Null" as the result if true
- Previous by thread: Re: What's max limit for MAXLOCKSPERFILE in registry?
- Next by thread: Re: how do I pirnt the lines in the excel ledger
- Index(es):
Relevant Pages
|
