compact.asp


 

Internet Support Specialists
SUPPORT UNLIMITED, INC.: HOW TO...

Compact Your Database

Microsoft Access® is a powerful database management tool that is very flexible and can range from very small to very complex applications. We have noted that the best performance will be achieved when using Access if you remember to compact your database regularly. As you add and store your information in your database, the information can become fragmented over time and decrease the performance of your database. To compact your existing database select:

  • Tools
  • Database
  • Utilities
  • Compact Database

In Microsoft Access® 2000, you can set this to automatically happen each time you close your database. To set this option:

  • Tools
  • Options
  • General Tab
  • Check the option: Compact on Close
  • Apply
  • OK

Microsoft Access® is a registered trademark of Microsoft Corporation and is not affiliated with Support Unlimited or its associates.

^ top