[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines


Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index
What is MS Access

Compacting Database

 

Compacting Database. As you make changes to the database in Design view, you may notice that it will grow in size very quickly. To return your database to a reasonable size you will need to compact it.

Compacting database:

  • Open the database in Design view, click on Tools > Database Utilities > Compact and Repair.

This should reduce your database back to close to its original size.

Do you like this tip? Subscribe to my Newsletter to receive tips via email. Click Here to subscribe.

www.simply-access.com (c) 2002 - 2009