From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

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

Compact and repair the database

Compact and repair the database

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Compact and repair the database

“

- [Instructor] When working with your database files, Access keeps track of the changes that you're making in the background and when you delete an object or lots of records, Access doesn't actually give you that disk space back right away. If you notice that your database is running slower or you'd like to squeeze the file size down as much possible, you can use a little tool called compact and repair. You'll find the compact and repair tool either on the database tools tab here in the very first position or you can also find it if you go to the file tab and in the info section, you'll find a copy of it there as well. Either place will accomplish the same task. Now when you click on the button, Access will close the database file then run through some routine maintenance tasks. It throws out old log-in information, rebuilds indexes and just generally cleans up after itself. Then the database file is saved again and reopened. Now for some databases, the compact and repair process is…

Contents