Compact Access MDB from DTS Package

#1

How would you do the following in a DTS package if MS
Access was not installed on the server?

Set obj = CreateObject("Access.Application.9")
obj.DbEngine.CompactDatabase strPathToMDB ,strTempDB

Is there another object used by dts to work with Access
databases that would allow the database to be compacted.

Last step in the package. Would be nice to do final clean
up.

Thanks

#2

Take a look at the following article:
HOWTO: Compact Microsoft Access Database Through ADO
http://support.microsoft.com/?id=230501

-Sue

On Fri, 16 Apr 2004 06:18:18 -0700, "Andy"
<akerns (AT) ers (DOT) usda.gov> wrote:

Quote:

How would you do the following in a DTS package if MS
Access was not installed on the server?

Set obj = CreateObject("Access.Application.9")
obj.DbEngine.CompactDatabase strPathToMDB ,strTempDB

Is there another object used by dts to work with Access
databases that would allow the database to be compacted.

Last step in the package. Would be nice to do final clean
up.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Compact Access MDB from DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Compact Access MDB from DTS Package - 04-16-2004 , 08:18 AM

Re: Compact Access MDB from DTS Package - 04-16-2004 , 08:45 AM