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.
This option effectively re-arranges all the active records, so you must run the ‘Audit Pointers’ function after using this option.
Article ID: 1541
Created On: Wed, Jul 4, 2012 at 9:21 AM
Last Updated On: Mon, Jun 12, 2023 at 5:03 PM
Online URL: https://kb.datafile.co.uk/article/compact-audit-database-1541.html