There is a problem here... since this is a hosted server, I have no idea of the full path of the mdb (c:\\temp\\junk.mdb, in your example)... but I do know the DSN name... is there anyway to do this compression with this constraint?
Regards,
Rajesh
Actually ignore my question! It was pretty stupid actually... I used Cwd to figure out the fullpath :-)...now all I have to do is check whether the code works and come back here to thank you...