Compress the Database

To compress the database by removing records of items that have been marked as deleted, or in the case of revision tables, records of superseded revisions, select either the Compress Database option from the Settings menu of File tab, or select the Compress Database option from the Options group of Home tab.

The Select Tables dialog is then displayed:

Check the checkboxes of the tables to be compressed and click OK.

To check or uncheck all the checkboxes, right-click and click on the required menu from the menu that is then displayed.

The user will be asked to confirm the compression. Click OK.

All records in the selected tables with a record status of 'D', or in the case of revision tables, with an issue status of ‘Superseded’, are then deleted from those tables.