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 ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
