G
ghetto_banjo
I have created a batch process on a remote computer, that opens up an
access database every night. I have a form that opens automatically,
and in the On Open event I run some code, call another batch process
that runs some FTP commands, and then code that sends an email to
myself saying that everything was successful (upon an error, a
different email is created). I keep Outlook open on that machine, and
I have software called ClickYes that automatically choose 'Yes' for
the dialog box that says "another program is trying to send email..."
I know that the process is working because I see the new file in the
FTP folder each morning, but for some reason I never get an email.
Nothing in the Outbox / Sent Items of Outlook.
If I actually log onto the computer and run the process, the email
gets generated and sent without any problems or intervention. For
some reason, it does not happen overnight when the computer is
unattended.
I have confirmed that the power saving schemes are disabled and such.
Where do I start troubleshooting? Is this Outlook or Access causing
the issue?
access database every night. I have a form that opens automatically,
and in the On Open event I run some code, call another batch process
that runs some FTP commands, and then code that sends an email to
myself saying that everything was successful (upon an error, a
different email is created). I keep Outlook open on that machine, and
I have software called ClickYes that automatically choose 'Yes' for
the dialog box that says "another program is trying to send email..."
I know that the process is working because I see the new file in the
FTP folder each morning, but for some reason I never get an email.
Nothing in the Outbox / Sent Items of Outlook.
If I actually log onto the computer and run the process, the email
gets generated and sent without any problems or intervention. For
some reason, it does not happen overnight when the computer is
unattended.
I have confirmed that the power saving schemes are disabled and such.
Where do I start troubleshooting? Is this Outlook or Access causing
the issue?