Hello, I would like to call the DAO
DBEngine.compactdatabase method to compact an Access
database before I populate it with new data.

I need to run this as part of an ActiveX task in a DTS
package. Can someone show me a VBscript code sample to
accomplish this?

Many thanks!

Ric

What about using JET. Call the CompactDatabase method. It will want to
create a new DB i.e. not in place. Do this. Delete the old and rename the
new.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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