Re: What's max limit for MAXLOCKSPERFILE in registry?



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)

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


.



Relevant Pages

  • Re: Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is
    ... you've hit, never having tested with anything like that many. ... which might only become apparent when a full recalc occurs on open. ... time to start thinking in other directions to address the issues that I ... Excel 2002 should be able to handle up to about 160MB of RAM ...
    (microsoft.public.excel.programming)
  • Re: process a BIG string
    ... I won't hit the memory limit because i only read about 10 to 64Kb at a ... in buffers of about 8192bytes and process each buffer, ... the problem is that with large filesi get a script error(Fatal ... You might also hit the roof of your memory usage if you handle and process ...
    (comp.lang.php)
  • Re: Fwd: NUCULAR fielded text searchable indexing
    ... have enough ram to cache your entire index. ... performance with disk based indices, ... In one java shop I worked in the web interface worked ... ok provided it was only hit by one access at a time, ...
    (comp.lang.python)
  • Re: pc wont boot from CD and CMOS is unaccessible
    ... I hit something I've never seen before. ... The computer start-up process goes as far as counting the RAM, ... My first thought was to boot from my boot disk (think ... hardware group. ...
    (microsoft.public.windowsxp.general)
  • pc wont boot from CD and CMOS is unaccessible
    ... Acer laptop) which she complained didn't start. ... I hit something I've never seen before. ... The computer start-up process goes as far as counting the RAM, ... My first thought was to boot from my boot disk (think ...
    (microsoft.public.windowsxp.general)