|
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 |