1316
Index
distributing, 846–848
restrictions, 847
optimizing applications, Compile on Demand option
checking status of, 843
compiled state, 848–854
overview, 843–844
turning off, 843
optimizing applications, compiled state
creating, 849–850
distributing applications, 851–854
library databases, 851–853
library references, 851–853
losing, 850–851
overview, 848–854
storing code, 851–853
optimizing applications, large databases
average size, 872
compacting, 874–875
compiling, 874–875
corrupted forms, 874
decompile option, 876
growth rate, 873
memory leaks, 874
minimizing changes, 879
pre-release steps, 877
rebooting, 874
recompiling automatically, 877
recreating, 874–875
uncompiled databases, detecting, 877–878
optimizing applications, perceived speed
definition, 867
forms, hiding versus closing, 868
hourglass cursor, 868
morphing forms or reports, 868
progress meter, 869–872
splash screens, 867–868
optimizing databases
average size, 872
compacting, 874–875
compiling, 874–875
corrupted forms, 874
decompile option, 876
growth rate, 873
memory leaks, 874
minimizing changes, 879
pre-release steps, 877
rebooting, 874
recompiling automatically, 877operators, string (continued)
list of, 178
Not Like (dissimilar strings), 179–180, 188
wildcards, 181
optimistic locking, 766, 769
optimizing applications. See also performance.
.accdb file format, 844–846
default database file format, 845–846
load on demand, 841–842
pruning the call tree, 842–844
supported file formats, 844
optimizing applications, absolute speed
changing variables, 864
closing unused applications, 856
combo boxes, 861
compacting databases, 855–856
comparing variables, 864
control variables, 864–865
data types, 862–863
dead code, removing, 866
definition, 854
defragmenting hard drives, 856
For Each function, 864
field variables, 865
finding data in code, 865–866
FindNext method, 865–866
FindRecord method, 865–866
forms, 859–861
With function, 864
IIF function versus If...Then...Else, 864
list boxes, 861
marking records with bookmarks, 866
memory, 856
modules, 862–866
network performance, 866–867
overview, 854–855
queries, 858–859
reports, 859–861
Requery method versus Requery action, 864
resolving references, OLE automation, 864
routines, 863–866
swap files, 856
table indexes, 856–858
tuning the system, 856
unused variables, removing, 866
optimizing applications, .accde files
application demos, 847
converting to normal database files, 847
creating, 847–84852_475348-bindex.indd 131652_475348-bindex.indd 1316 4/1/10 2:02 PM4/1/10 2:02 PM