Thanks for your replies. I think we're going to try a different approach rather than DTS.
Just to make my question a little clearer, I'll explain the scenario.
We have a SQL Server database which stores online internet activity for a range of clients. This database is currently 24 GB. We export individual client data to seperate Access databases (so in effect, each client has its own access database containing it's own activity for the current week).
At the end of the week, we empty the access database and export the current week's online data. So to summarise, our SQL Server is the datawarehouse, the Access database just gets updated with the last 7 days worth of activity.
Even though we delete data from the Access database and put new data in there, the file size continues to grow. Therefore, we need to compact the access files once they've been updated.
From what I gather, DTS isn't the best approach for this final step, so we're going to write a VB app and schedule it to run at certain intervals.
Thanks for everyones feed back.