Solved

Complicated Access 2003 sending Emails Issue

Posted on 2011-09-27
6
230 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

At the beginning of the year, the IT world was taken hostage by the shareholders of LogMeIn. Their free product, which had been free for ten years, all of the sudden became a "pay" product. Now, I am the first person who will say that software maker…
Let’s list some of the technologies that enable smooth teleworking. 
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

747 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