[AccessD] How to tell how much resources have been used

[Bill Benson]

I put some metrics-oriented code around the routines, and found the results
interesting. At time of the first suggestion to restart, Access had
finished all the reports without reporting an error, however when I went to
close the database, I was informed that there were not enough resources. I
don't know what routines Access needs to run on shut down, but it is
interesting that the last report got in just under the "wire." What I have
learned from this attempt however is that there is really no safe number of
reports that can be run prior to restart. So I am continuing to try to
implement the suggestion given to run reports from a second instance of
Access and shut it down.

One thing I will be trying to do is monitor memory usage by the *second*
instance of Access. I don't think I will be able to perform that monitoring
from within the first instance, probably I will need have the called remote
database run its own memory check, and export the result to a text file
that the master instance can then open and read after each separate report
is run. If a certain dangerous level is reached, then it would be time to
restart the remote database. I am thinking along these lines because I
would only want to start the remote instance as often as necessary for it
to produce reports safely without running out of resources. It seems to be
a process that consumes about 20 to 30 mb of resources per report being run.

Anyone have additional thoughts / caveats?

Memory in use: 680.6 mb before running any reports.
Memory in use: 710.9 mb. Used 30.3 mb from running 1 report
Memory in use: 732.1 mb. Used 51.4 mb from running 2 reports
Memory in use: 749.1 mb. Used 68.5 mb from running 2 reports
Memory in use: 770.0 mb. Used 89.4 mb from running 3 reports
Memory in use: 790.0 mb. Used 109.3 mb from running 1 report
Memory in use: 810.0 mb. Used 129.3 mb from running 2 reports
Memory in use: 829.8 mb. Used 149.2 mb from running 3 reports
Memory in use: 850.0 mb. Used 169.3 mb from running 4 reports
Memory in use: 869.7 mb. Used 189.1 mb from running 5 reports
Memory in use: 889.5 mb. Used 208.9 mb from running 6 reports
Memory in use: 909.9 mb. Used 229.2 mb from running 7 reports
Memory in use: 929.6 mb. Used 249.0 mb from running 8 reports
Memory in use: 949.2 mb. Used 268.5 mb from running 9 reports
Memory in use: 969.1 mb. Used 288.5 mb from running 10 reports
Memory in use: 989.6 mb. Used 309.0 mb from running 11 reports
Memory in use: 1009.2 mb. Used 328.5 mb from running 12 reports
Memory in use: 1029.9 mb. Used 349.3 mb from running 13 reports
Memory in use: 1049.4 mb. Used 368.7 mb from running 14 reports
Memory in use: 1069.3 mb. Used 388.6 mb from running 15 reports
Memory in use: 1089.3 mb. Used 408.7 mb from running 16 reports
Memory in use: 1109.1 mb. Used 428.5 mb from running 17 reports
Memory in use: 1129.5 mb. Used 448.9 mb from running 18 reports
Memory in use: 1149.2 mb. Used 468.6 mb from running 19 reports
Memory in use: 1169.1 mb. Used 488.5 mb from running 20 reports
Memory in use: 1189.5 mb. Used 508.8 mb from running 21 reports
Memory in use: 1209.7 mb. Used 529.0 mb from running 22 reports
Memory in use: 1229.2 mb. Used 548.6 mb from running 23 reports
Memory in use: 1248.7 mb. Used 568.1 mb from running 24 reports
Memory in use: 1268.7 mb. Used 588.1 mb from running 25 reports
Memory in use: 1289.0 mb. Used 608.4 mb from running 26 reports
Memory in use: 1308.9 mb. Used 628.3 mb from running 27 reports
Memory in use: 1328.8 mb. Used 648.2 mb from running 28 reports
Memory in use: 1348.8 mb. Used 668.2 mb from running 29 reports
Memory in use: 1368.6 mb. Used 688.0 mb from running 30 reports
Memory in use: 1389.1 mb. Used 708.5 mb from running 31 reports
Memory in use: 1408.3 mb. Used 727.7 mb from running 32 reports

After restart, continuing the batch reports

Memory in use: 135.5 mb. Used 50.3 mb from running 1 report
Memory in use: 145.1 mb. Used 59.8 mb from running 2 reports
Memory in use: 167.9 mb. Used 82.6 mb from running 3 reports
Memory in use: 187.7 mb. Used 102.5 mb from running 4 reports
Memory in use: 207.2 mb. Used 121.9 mb from running 5 reports
Memory in use: 226.9 mb. Used 141.6 mb from running 6 reports
Memory in use: 246.6 mb. Used 161.3 mb from running 7 reports
Memory in use: 273.5 mb. Used 188.2 mb from running 8 reports
Memory in use: 294.3 mb. Used 209.1 mb from running 9 reports
Memory in use: 315.4 mb. Used 230.2 mb from running 10 reports
Memory in use: 334.9 mb. Used 249.6 mb from running 11 reports
Memory in use: 356.5 mb. Used 271.3 mb from running 12 reports
Memory in use: 376.5 mb. Used 291.2 mb from running 13 reports
Memory in use: 397.1 mb. Used 311.8 mb from running 14 reports
Memory in use: 417.1 mb. Used 331.9 mb from running 15 reports
Memory in use: 437.9 mb. Used 352.6 mb from running 16 reports
Memory in use: 457.8 mb. Used 372.5 mb from running 17 reports
Memory in use: 477.7 mb. Used 392.4 mb from running 18 reports
Memory in use: 497.9 mb. Used 412.6 mb from running 19 reports
Memory in use: 518.4 mb. Used 433.1 mb from running 20 reports
Memory in use: 537.9 mb. Used 452.7 mb from running 21 reports
Memory in use: 559.0 mb. Used 473.7 mb from running 22 reports
Memory in use: 578.8 mb. Used 493.5 mb from running 23 reports
Memory in use: 599.0 mb. Used 513.8 mb from running 24 reports
Memory in use: 619.7 mb. Used 534.4 mb from running 25 reports
Memory in use: 640.2 mb. Used 554.9 mb from running 26 reports
Memory in use: 660.4 mb. Used 575.1 mb from running 27 reports
Memory in use: 680.5 mb. Used 595.2 mb from running 28 reports
Memory in use: 700.7 mb. Used 615.4 mb from running 29 reports
Memory in use: 720.8 mb. Used 635.5 mb from running 30 reports
Memory in use: 741.7 mb. Used 656.4 mb from running 31 reports
Memory in use: 761.2 mb. Used 675.9 mb from running 32 reports
Memory in use: 781.8 mb. Used 696.5 mb from running 33 reports