Is there a way to execute a "Compact and Repair" process
in DTS for an access database. Problem is, I create an
Access database from the DTS process, then I upload it
using FTP.exe, but I noticed that when I compact and
repair the Access database it shrinks down to about half
the size. Does anyone know if it is possible to compact
and repair a database as an DTS process?

You would need to use the ActiveX script. You would need to initialize a DAO database object and then open the database

The main difficulty you would have in doing this is that you will need to close all of your connections to the Access database to do it

Russ

On Wed, 18 Feb 2004 15:41:08 -0800, Russel Loski wrote:

Or JRO. Just create an instance of JRO.JetEngine, and call the method
CompactDatabase giving it the source name and destination name.
Afterwards, you could use the FileSystemObject to move the new,
compacted database over the old database file.

--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander

Microsoft has a utility called JetComp.exe that may have some useful command
line parameters...not really sure.

http://support.microsoft.com/default...56&Product=acc

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

"Shawn" <anonymous (AT) discussions (DOT) microsoft.com> wrote