Home
What is MS Access
Tables
Forms
Queries
Reports
VBA Codes
Learn VBA
Access 2007/10
Access 97
Tips via email
Whats New!
Contact Me
Questions Answered

[?] Subscribe To This Site

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


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