Repairing and compacting the database file
Use the Repair/Compact command to reduce the fragmentation of tables in a Microsoft™ Access database where many records have been changed or removed. This command removes only the space that is marked as being unused in the database. For SQL Server databases, it only compacts the connection file.
About this task
You must be logged on to the relevant security file but have the database closed.
Procedure
In iBase Designer, select Tools > Database Administration > Repair/Compact > Database File.
Check that the result is success.
What to do next
Whether or not you see a successful report, complete the other checks described next: