Solved

Complicated Access 2003 sending Emails Issue

Posted on 2011-09-27
6
264 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
Changing a few Outlook Options can help keep you organized!
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

739 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