O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

COMPACTING AND REPAIRING THE BACK END ON DEMAND

Although the front-end application can perform the compact/repair itself, it's necessary to log other users out of the back end and test to make sure that no one else is in the application. The form that's used for compacting the back end is ap_CompactDatabase (see Figure 28.7).

Figure 28.7. This form appears while the application tries to compact the back end.

Most work performed by the ap_CompactDatabase form is in the OnLoad event.

Three of the routines called in Listing 28.2-ap_LogOutCheck, ap_LogOutCreate, and ap_LogOutRemove—are used to check, create, and remove the flag file in the back-end ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required