Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Complicated Access 2003 sending Emails Issue

Posted on 2011-09-27
6
Medium Priority
?
273 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

604 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