Office 97 Tips

Speeding Up Your Access Files

If you have a large database from which you primarily read data, you may never need to compact it. However, a database that you constantly write data to, and delete data from, will soon become extremely fragmented; and you may begin to notice that it doesn't run as fast as it did in the old days.

What you need to do is compact those fragmented Access database files. Here's how:
Close the database you want to compact. Choose Tools|Database Utilities|Compact Database. When the dialog box opens, select the file you want to compact, and Access will automatically assign a new name to the output file. Click on Compact and then click on Save to save your new compacted file.

If you want to save back to the original file name, you can make the change here (in the Save dialog box). Type in the new (original) name and click on Save. Access will warn you that you're about to overwrite your original file.


Return to the Program Tips index


FAQ Articles DirectX Plus98! Downloads Drivers News Archive
Home, Links, Awards, Help, Map, Poll, Newsgroups, Online Chat, Mailing List, Search
Tips & Tricks Guides Bugs & Fixes Themes Reviews Site Contents ActiveIE

HR Line

Copyright (C) 1998-1999 The Active Network. All rights reserved.
Please click here for full terms of use and restrictions.