TechTalk: Compact and Repair Page 1 2 3 4

Office -> Manage -> Compact and Repair

 

Compact and Repair

Try it: Compact and Repair

Close and Save all of your tables, forms and queries before you begin.

 

Go to Office ->Manage

Select Compact and Repair Database.

 

It happens so quickly you may wonder if it worked. If you have a large, fragmented database, you may see a progress bar on the bottom of your Window as the process moves along. Be patient: a big database may take several minutes to Compact and Repair.

 

When the maintenance is done, your database will open again.

 

Computers! Yea, we love them, don’t we?

 

DONE

 

  Microsoft Access 2007 Exam 77-605 Topic: 6. Managing and Maintaining Databases 

  6.1. Perform routine database operations  6.1.3.   Compact and repair databases