DTS to Compact a Access Database

[tseh]

I update a Access db to send out to remote locations. Everytime I run the DTS it doubles the size and I want to compact as one of the steps. How can this be done using DTS?

Thanks

 

[DougP]

Maybe??? (But this will only work if Access is loaded on the machine where you are running the DTS)

Create a Batch file called
CompactMydb.bat
Inside the file have just one line as follows:
MSAccess.exe databasename /compact

Then run this Batch file after you transfer the data.
In your DTS pacakge add a new task called
Execute Process Task
Browse for your newly created batch file in the "Win32 process" box.
DougP, MCP