🚀 go-pugleaf

Save backups into another Access database, or even you may have one database
for every month. Then when your user needs older records you do

SELECT * FROM MyTable IN "C:\Backups\2003_04.mdb"
UNION
SELECT * FROM MyTable IN "C:\Backups\2003_05.mdb"

Do not forget to compact database when you place it into backup.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Andrew" <alamb@tynetec.co.uk> �������/�������� � �������� ���������:
news:3f584ba5@newsgroups.borland.com...
> 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
>
>