🚀 go-pugleaf

Hi All,

I have an app that has a TADOConnection, TADOTables, TADOQuery etc
connecting to an Access database, every day I archive the records older than
30 days using TADOTable->SaveToFile("Filename", Format);.

Now if someone wants to query the data that has been archived I have to
re-load the saved data into a TADOTable using
TADOTable->LoadFromFile("Filename");, then copy each record to a temporary
table within the database, then query that table to retrieve the records
that the user was looking for. Once the query is complete I delete all the
records in the temporary table and all is complete, I perform a compact and
repair on the database every night when the archive operation is complete so
the database tables are kept to a minimum size and the temporary table does
not grow to large.

This seems straight forward enough but a little contrived, I was wondering
if anyone has a better suggestion or is this the only way to do this sort of
action.

Thanks in advance

Andrew