Access™ 2007 VBA Programmer's Reference

D.2. Undocumented Tools and Resources

Several Access-specific utilities and object methods are shipped with Microsoft Access 2007. These utilities and methods are not very well documented by Microsoft or are not documented at all. Nonetheless, you can use them to help you develop and maintain your DAO applications.

D.2.1. Utilities ISAMStats

Microsoft Access 2007 contains an undocumented DBEngine method called ISAMStats, which returns various internal statistics. You use ISAMStats to get statistics about different operations. For example, to determine which of several queries will run faster, you can use ISAMStats to return the number of disk reads performed by each query.

Each of the ISAMStats options maintains a separate statistics counter that records the number of times its metric occurs. To reset the counter, set the Reset argument to True. The syntax is as follows:

lngReturn = DBEngine.ISAMStats(StatNum [, Reset])

where StatNum is one of the following values:

StatNum Value	Description
0	Number of disk reads.
1	Number of disk writes.
3	Number of reads from cache.
4	Number of reads from read-ahead cache.
5	Number of locks placed.
6	Number of locks released.

You must call ISAMStats twice: once to get a baseline statistic and once (after the operation to be analyzed) to get the final statistic. Then you subtract the baseline statistic from the final one to arrive at the statistic for the operation under test. The following examples demonstrate two ways to use ISAMStats:

D.2.1.1. Method ...