🚀 go-pugleaf

BTW, you may do your backups with SQL too:

1. Create backup database with ADOX.
2.
SELECT * INTO MyTable IN "C:\Backups\2003_04.mdb" FROM MyTable WHERE
[Date_Column] < DateSerial(2003, 5, 1)
3.
DELETE * FROM MyTable WHERE [Date_Column] < DateSerial(2003, 5, 1)
4.
Now you may compact both databases (current and 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:3f58916d@newsgroups.borland.com...
> Many thanks Viatcheslav,
>
> That works perfectly and is far quicker than my current method.
>
> Andrew.
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:3f587dfa$1@newsgroups.borland.com...
> > 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.
>
>
>