Thanks Jay. I am going to use BtrieveBills solution in this instance as I have a user running a Crystal report using direct SQL queries, and I only want to archive and compress once a month. Co-incidentally though, your suggestion solved another problem I was wondering about.