Microsoft Access 2010 Bible

Chapter 24: Optimizing Access Applications

879

FIGURE 24.18

A module to automatically compile and compact your database

Making small changes to large databases

When you’re making lots of changes to a database, you’re constantly opening and closing objects.

Work with a copy of the database, and then when you have the changes just the way you want,

export the changed objects to the production database. (An exported object with the same name as

an object in the production database is exported with a 1 at the end of its name.) You can then

delete the original object in the production database, and rename the exported objects. New

objects are exported with their name intact.

The fewer changes to a large database, the better off you are. By following the tips and techniques

in this section, you’ll have fewer problems and be more productive.

Summary

In this chapter, you learned techniques to improve the performance and operation of your data-

base. You learned how to set up tables, queries, forms, and reports to optimize performance. You

saw techniques to take a problem database and turn it into a working database. You even used

methods to make the user think an application is running faster.

Through judicious use of the techniques discussed in this chapter, you can increase the perfor-

mance of your Access application to the highest level possible.