Removes any empty space from a database file.
function CompactDatabase(NewDatabaseFileName: String): Boolean; overload;
function CompactDatabase: Boolean; overload;
CompactDatabase physically removes any empty space from a database file.
If NewDatabaseFileName specified then a new compact copy of a database is created.
If some tables were corrupted, CompactDatabase raises an exception. It is recommended to call RepairDatabase in such a case.
Note: Compacting a database could be a lengthy process if you are working with large database. Use BeforeCompact, OnCompactProgress and AfterCompact event handlers to display the progress of a compacting database process.