In ECMap’s main window, select Utilities > Compact Databases. The following actions occur:
Unused space created by deletions is reclaimed. When rows are deleted from the database, Access marks them as available but does not actually release the space. The resulting database size is not reduced until the database is compacted.
Table pages are placed adjacent to one another. This makes processing more efficient because the parts of each table are contiguous and not scattered across the database.
Table pages are ordered by the primary key. Access does not maintain the primary key order when records are added, deleted, or modified after the database is compacted. Reordering the table pages allows the program to read ahead more efficiently.
Table statistics used in the query optimization process are regenerated. This removes any problems with out-of-date statistics that are the result of rollbacks or improper closing of the database.
All queries are flagged to be recompiled the next time the query runs. Because database statistics can change over time, previously compiled queries can contain inaccurate optimization information.
