Hello, I have a DTS package that contains an ActiveX
script. This script compacts an Access database.

If I have the package open in the designer and run it
everything works fine. The Access database is compacted.

However, if I run the package as a job it fails. I see
the following error in the job history:

Error Source=MicrosoftVBScript runtime error Error
Description:ActiveX component can't create object:'Access
Application.9' Error on line 25

I am using SQL 7 and Access 2000. This problem is driving
me crazy! Any help would be appreciated

Ric

Usually this problem occurs because of permissions

Have a look at this

http://support.microsoft.com/?kbid=269074

--
--

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