CDO messaging app wont run unattended

[TimK01]

I have created a small app in V6 that accesses Access databases and uses CDO to send messages via Outlook.

I want to run it nightly

I have set it up in Scheduled Tasks and it runs fine, as long as I am signed on on the server (as the Administrator)!

If I sign off the job shows as having a Last Result of 0x1 and nothing appears to happen.

I have set the job to run as the Administrator on the task tab of the Scheduler to no effect.

The job has no user interface, but does require a network share to be in place which I have double checked by placing the app in a batch file that recreates the network share first.

ANy assistance or ideas greatly appreciated.

(Cross posted to the NT4 forum)

Tim

 

[TomKane]

What we did was we used some scheduling software that came with our accounting system. But the PC has to be on and signed in for that to work (not administrator though).

One of my colleagues wrote a program that just sits there and the timer control checks to see what time it is and when the time is right the app executes.

I understand that wintask have a supposedly decent peice of scheduling software.

Or you could make the app a service?