Microsoft Access 2010 Bible

Part IV: Professional Database Development

878

One line of code can be added anywhere in your program to detect an uncompiled application and

start the process:

If IsCompiled() = False Then DoCmd.OpenForm “MessageImprovingPerformance”

FIGURE 24.16

Checking to see if an Access database is compiled

The form is displayed (see Figure 24.17) if the application isn’t compiled. Users are given the

choice of recompling or proceeding without compilation.

FIGURE 24.17

A form to help the user compile your application

The compile and compact code is shown in Figure 24.18.