What's max limit for MAXLOCKSPERFILE in registry?

P

PDIHAL

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?
 
G

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)
 
P

PDIHAL

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