I use a program to extract data from text reports which has the capability to export to an Access database. Using the manual export, I can use this program to append records to any table that I specify, but the automatic procedure (using command line options) defaults to replacing the target database completely. To overcome this deficiency, I have my automated exports go to a temporary holding database, link my main database table to the temp, and then query-append the data. This gives me all of my data, but also leaves the temp database full -- wasting disk space. I could query-delete the records from the temp table, but that doesn't reclaim the wasted space.

I would like to issue a "Compact" command on this temp database as a final step in the data transfer process, but the "RunCommand: CompactDatabase" macro command doesn't like what I am trying to do. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> Simply deleting the temp database is not a practical alternative at this time.

Any suggestions on how to accomplish this compacting automatically?