From the course: Access 2007: Shortcuts

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Compacting and repairing a database

Compacting and repairing a database - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

Compacting and repairing a database

It's important to do maintenance on your database once in a while. Compacting and repairing your Access file keeps it running smoothly and minimizes your file size. If you find that your database is slowing down or becomes corrupted, Access could use a repair. Or, when you delete records out of your database, Access does not reclaim the disk space and your file size does not get any smaller. To solve both of those issues, perform a Compact and Repair on it. Go up to the Office button, and down to Manage. Choose Compact and Repair Database. Access will trim down your file size and keep itself running smoothly. Be sure to do a Compact and Repair periodically, especially after large deletions.

Contents