Access not sending email overnight

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?

I'd start with what has changed recently?

Also if the computer has user-level security where you have to log in as an
individual, you may need to run the process as the computer Administrator.
Try not logging out of the computer in question and see what happens. I would
even disable the locking of the computer by the screen saver for testing
purposes.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"ghetto_banjo" wrote:

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?

well its a new process, so nothing has changed since its
implementation.



I actually keep the computer logged in as a local administrator. I
will need to check with the screensaver, that is probably enforced by
the domain rules. Just seems strange that everything is working fine
except the email part. Perhaps the ClickYes software isn't working
and the email never gets to Outlook....

Have you considered using Outlook Redemption which allows you to send
an email via Outlook but bypasses the security message that you are
using ClickYes to cancel. If so, then I have some code which you may
be able to use. Post back if you would like to try it out.

Peter Hibbs.

On Tue, 7 Jul 2009 11:04:51 -0700 (PDT), ghetto_banjo
wrote:

well its a new process, so nothing has changed since its
implementation.



I actually keep the computer logged in as a local administrator. I
will need to check with the screensaver, that is probably enforced by
the domain rules. Just seems strange that everything is working fine
except the email part. Perhaps the ClickYes software isn't working
and the email never gets to Outlook....