The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted. New records are always added to the end of the file. Therefore, over a period of time, it is possible a file may appear full but there could be gaps in the middle, where records were deleted. Using this option consolidates the active data and frees up space.
Article ID: 883
Created On: Tue, Jun 26, 2012 at 11:18 AM
Last Updated On: Tue, Jun 13, 2023 at 12:50 PM
Online URL: https://kb.datafile.co.uk/article/compact-audit-database-883.html