The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the nominal account file). 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. In addition you should not, in the normal course of events, use this option on the transaction file – the journal clear down process will do this for you and running here could affect the transaction control numbers (see above).
Article ID: 1159
Created On: Thu, Jun 28, 2012 at 11:43 AM
Last Updated On: Mon, Jun 19, 2023 at 6:29 PM
Online URL: https://kb.datafile.co.uk/article/compact-audit-database-cashbook-1159.html