Free E-Books

For example, if you
call procedure A in module A, any modules that contain procedures referenced in procedure A are
loaded and compiled. However, Access 2007 doesn??™t take into consideration procedures that may
be called from other procedures in module A, and it doesn??™t look at the potential call tree of the
modules loaded because one of their procedures is referenced in procedure A. Because Access 2007
loads modules one-deep from the executed procedure??™s immediate call tree only??”and not the
module??™s call tree??”your applications should load and execute many times faster than they did in
previous versions.
Even though Access 2007 has made a significant improvement in the way modules are loaded and
compiled, you can still do a number of things to reduce the number of modules loaded and compiled.
For example, you should never place infrequently called procedures in a module with procedures that
are called often. At times, this may make your modules less logical and harder to conceptualize.


Pages:
1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567