Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Database Housekeeping
Chapter 1: Database Housekeeping
In This Chapter
Taking out the garbage (compacting your database)
Backing up part or all of the database
Analyzing how the objects in your database work together
Loading Access add-ins
An Access database can get big and complicated, with dozens or even
hundreds of objects — tables, queries, forms, reports, macros, and
other stuff that you find out about in other parts of the book. You need to
keep your database neat and tidy; otherwise, it becomes just plain confusing
to use, and the file size balloons. This chapter describes how to compact,
repair, back up, analyze, and configure your database.
Compacting and Repairing Your Database
When you make changes to your database, Access stores new information in
the database file and marks the old information for deletion. The old
information isn’t actually removed from your database file right away, however.
In fact, most database files have a tendency to get larger and larger because
Access (like most other programs) isn’t very good at taking out the garbage.
To shrink your database, you have to compact the database file.
The process of compacting a database also repairs errors that crop up in the
file. Occasional Access bugs, Windows bugs, or cosmic rays from a black hole
in another galaxy can cause objects in the database to become corrupted —
or broken, if you prefer a more straightforward term. Compacting the
database repairs these corrupted objects.
To compact and repair your database when the database is open, follow
these steps:
1. Close all tables, queries, forms, reports, and other database objects,
including the Visual Basic Editor.
Access can’t compact the database if objects are open.
2. Click the File tab of the Ribbon to see Backstage View.
Search JabSto ::

Custom Search