Hello, I have created a DTS package that inserts and
deletes records in an Access database. I would like to
run the Compact method against the Access database when
the package completes. I imagine this will have to be
done with an ActiveX script task.

Is there anyone who can show me some sample code or
explain how this can be done?

Thanks!

Ric

In article <052f01c3a23f$a42344c0$a101280a (AT) phx (DOT) gbl>, Ric
<richard.hofing (AT) notes (DOT) canadair.ca> writes
You can do this in one of two ways-

Use the DAO CompactDatabase method

Use the Access exe with the "/compact" command line switch.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Darren, can you show me some sample code for the ActiveX task?

Ric



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <#zQpa3koDHA.2820 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Ric <ric (AT) ric (DOT) com>
writes
Some options. Search the KB on product Access 2000 and keyword compact-

ACC2000: Jet Compact Utility Available in Download Center
http://support.microsoft.com/default...b;en-us;273956

ACC2000: How to Compact Databases At a Scheduled Time
http://support.microsoft.com/default...b;en-us;209979

ACC2000: How to Use Command-Line Switches in Microsoft Access
http://support.microsoft.com/default...b;en-us;209207
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org