Mike,

I was thinking of adding the MAX Transaction to a GV last night when i got home i have just read your reply and it prompted me to have another look at...

Pete,

I compact an access db from a VB program each night so you may be able to use this to create an activeX DTS package

*******************************************

Dim jetDBEngine As DBEngine

Dim daoDB...

Thanks guys i have got it working now using Jonathans method.. i did have another problem this was in my DTS package i had a TRUNCATE TABLE statement and the...