Solved

Complicated Access 2003 sending Emails Issue

Posted on 2011-09-27
6
240 Views
Last Modified: 2012-05-12
I have a program (Access 2003) that generates an email and sends it.  
It works OK on a normal host.  
It works OK on a host using RDC if connected to that host.  
If the task is scheduled on a host that is only accessed thru RDC and the RDC connection is closed,  the task stops (hangs up really) until the RDC connection is re-established.
Click-Yes is running on the host on which the task is scheduled.
Does anyone know of an Outlook setting to cause it not to hang?
It takes off immediately when the RDC connection is re-established.
Thanks,  Miike (BFOG)
0
Comment
Question by:BFOG
  • 4
  • 2
6 Comments
 
LVL 84
ID: 36713614
Does the Task hang, or does Outlook hang?

If it's the Task, are you certain that the Task is set to run with a login that has sufficient permissions to run unattended tasks (generally this would be an Administrator-level login)?
0
 

Author Comment

by:BFOG
ID: 36713942
I am not certain.
The task is run as Administrator and has full rights.
I think it is Outlook since the message "A program is trying to access e-mail addresses you have stored in Outlook.  Do you want to allow this?  If this is unexpected..." is sitting on the screen when I RDC into the machine.  As soon as I connect the message goes away and the email is sent.  I think it has something to do with RDC interacting with Outlook.  Click-Yes will normally handle that process, - maybe Click-Yes is hung-up and can't answer the message.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 36715778
Could be. Are you using the full version of ClickYes, or are you using the free version? The free version doesn't work properly in TS/Citrix environments, nor does it work when the workstation is locked (i.e. unattended).

See here:

http://www.contextmagic.com/express-clickyes/

Notice fht feature matrix about halfway down that page in the section titled "Express ClickYes vs. ClickYes Pro. Which one suits you better".

Finally: IMO, ClickYes (and other programs like this) are a kluge, and should not be used where reliability and dependability are at stake. You are far better off using something like Redemption or (my favorite) vbMAPI to do this, as they don't rely on simply "clicking" an onscreen button (which may or may not work).

vbMapi: www.everythingaccess.com/vbMAPI.htm
Redemption: www.redemptionweb.com
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:BFOG
ID: 36718244
Thanks,  I'll try the pro version.
I'll also look at the references for the other software you suggested.
Mike
0
 

Author Comment

by:BFOG
ID: 36718328
BTW:  The redemption link goes to a site for a music group.
0
 

Author Closing Comment

by:BFOG
ID: 36720366
This really helped.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't know how to downgrade, my instructions below should be helpful.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now