What's max limit for MAXLOCKSPERFILE in registry?

[Guest]

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?

 

[Guest]

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)

 

[Guest]

What's the Jet Cache memory limit on a PC with 1GB PC4000 memory? How does
one find this value on his/her machine?

 

[Guest]

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)