[AccessD] System Resources Exceeded

[Mark Simms]

I'd like to know where this setting emanated and whether there are related dbEngine settings ?I have a client who is crashing in Windows 2010 on Access data entry forms that run perfectly fine in Windows 7.Any thoughts ?

dbEngine.Setoption dbMaxLocksPerFile , 500000  to your startup code


-----Original Message-----
From: Jim Dettman via AccessD <accessd at databaseadvisors.com>
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>; 'James Button' <jamesbutton at blueyonder.co.uk>
Sent: Wed, May 8, 2019 4:38 pm
Subject: Re: [AccessD] System Resources Exceeded

<< as in there is (or used to be) a 64MB limit in one of the memory pool
allocations.>>

  yes, that was for queries, but it was 64k.  Generation of the costing
plan and execution was limited to single 64k.  That limit was lifted quite a
while ago though and what it is now is not documented.

  There's also other internal limits, such as number of database connections
(not documented) and number of table ID's (2048) .  It also seems like there
is a general memory heap that's used, but often you'll will find that a
process runs OK, then minutes later will fail

 And somewhere there is a list of a number of restrictions (i.e. length of a
query name, number of control in a form, etc).

Jim.