Access has two types of code??”code that you write and code that Access can understand and execute.
Before VBA procedure that you have written can be executed, the code must be run through a
compiler to generate code in a form that Access understands??”compiled code.
Access lacks a true compiler and instead uses partially compiled code and an interpreter. A true
compiler converts source code to machine-level instructions, which are executed by your computer??™s
CPU. Access converts your source code to an intermediate state that it can rapidly interpret and execute.
The code in the converted form is known as compiled code, or as being in a compiled state.
NOTE
CAUTION
829
Optimizing Access Applications 26
If a procedure is called that isn??™t in a compiled state, the procedure must be compiled and the compiled
code passed to the interpreter for execution. In reality, as previously stated, this doesn??™t
happen at the procedure level, but at the module level. When you call a procedure, the module
containing the procedure and all modules that have procedures referenced in the called procedure
are loaded and compiled.
Pages:
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576