Lesson 2.16. Compacting and Repairing a Database
Figure 2-36. Use the Compact and Repair Database command to clean up the database.
Cars require maintenance to keep them running at their peak performance, and databases are no different. Your Access databases require some routine maintenance to prevent and/or correct problems and to keep them running at top performance. This lesson covers the two database utility commands:
Microsoft has combined compact and repair into a single command in Access 2003. If you have been busy adding, editing, and deleting records for a while or if your database seems buggy, sluggish, or is generating error messages, it would be a good idea to run the Compact and Repair Database command. Here's how to compact and repair a database: