G'day Chris,

Have you considered archiving to tables rather than text files? Much easier to query and restore.

One way to do it is to SELECT INTO the new table all the records you want to keep real-time access to, then take the (complete) old table off line.

The start of the Sydney-Horbart sounds nice. I'm going to be at the MCG on boxing day.

All the best for the Festive Season.

Cheers,

Andrew

>Andrew
>
>We already archive information by taking it from the active table and dumping it into a text file so that it can be retrieved later - but this was tooooo complicated to restore it, and report on it, hence the need to store more. Splitting the table is a good idea - something that I can work on...
>
>As far as the WI are concerned - I'd bet on a 5-0 result more than changing this stuff to SQL...perhaps they should get Sir Viv back on board - at least he got SOME runs this afternoon. Lets hoping Sydney puts on some good weather for the Syd-Hobart as we'll actually be in Sydernee to watch!
>
>Thanks again
>
>Cheers
>
>Chris