Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmartin
Starting Member
2 Posts |
 Posted - 2004-06-03 : 14:08:52
|
| I have read many threads on this issue & tried multiple solutions to no avail.Here's my environment: SQL 2000, Logged directly into server via VPN (so it should be like I am physically at the server).I've set up a DTS Package that executes an Access procedure. The package runs fine when I execute manually. When I execute via schedule, it fails on the error "ActiveX component can't create object: 'Access.Application'. The actual statement is:Set objDB = CreateObject("Access.Application")I know that Scheduled jobs default back to the SQL Agent permissions. I have reset SQL Agent to use my Windows NT account login so it should have the exact same permissions, etc. that I have when I execute manually?Any help will be GREATLY appreciated!!!Thanks mucho,Brian |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-03 : 14:16:52
|
| Did you restart the SQLSERVERAGENT service after you made the account change? If not, then the change hasn't taken affect yet.Tara |
 |
|
|
bmartin
Starting Member
2 Posts |
Posted - 2004-06-03 : 14:25:03
|
| Yep - I did stop & restart it. When I remove all the code & just leave a shell & schedule it, it works - it's like it doesn't think it has the authority to create the "object".Thanks for the reply! |
|
|
|
|
|
|
DTS schedule question