Is there a way to compact an Access 97 database that resides on my host&#039s server? I have many records that will need to be deleted on a weekly basis. I have an ASP program that will accomplish this. Only problem is it doesn&#039t reduce the size of the database and that will be a problem after a while. At present the DB is small and I download it from host server to my local machine, compress it, then upload to server again. As the DB grows this sill not be feasible. <BR><BR>Someone gave me this line of code to use but I don&#039t know how to use it and have had no success recontacting them to get instrs.<BR><BR>RetCode = WShShell.Run ("msaccess.exe d:dbdirectorydbname.mdb /compact")<BR><BR>Appreciate any help. <BR><BR>