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: 949
Created On: Wed, Jun 27, 2012 at 9:29 AM
Last Updated On: Mon, Jun 12, 2023 at 7:43 PM
Online URL: https://kb.datafile.co.uk/article/compact-and-audit-database-949.html