?
Solved

Complicated Access 2003 sending Emails Issue

Posted on 2011-09-27
6
Medium Priority
?
270 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:Michael Wolfstone
[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 85
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:Michael Wolfstone
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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:Michael Wolfstone
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:Michael Wolfstone
ID: 36718328
BTW:  The redemption link goes to a site for a music group.
0
 

Author Closing Comment

by:Michael Wolfstone
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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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