[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Microsoft Access 97 can't send a message in Windows Mail

Posted on 2009-05-14
7
Medium Priority
?
586 Views
Last Modified: 2013-12-17
I am using Access 97 and running a macro using sendobject. This macro has worked with access 97, outlook express, and windows xp.

I have now tried this macro on a vista machine using windows mail. But I get an error: Microsoft  access can't send a message for the reason stated in the preceeding Alert. Resolve the problem and then send again. I do not see any preceeding alert.

Any help appreciated

Tom
0
Comment
Question by:Tomcpt
[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
  • 3
  • 2
  • 2
7 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 24392718
Tomcpt,

See this link:
http://support.microsoft.com/kb/262997
and this perhaps:
http://www.access-programmers.co.uk/forums/showthread.php?p=497985

Please be aware that there is a 12 year difference in technology between the two products you are using.

Although Access 97 will run on vista, Microsoft may not guarantee that all the functionality will work.

Many Files are shared between MSOffice and MSWindows.
The files that Access 97 might need, may not be available in Vista.

Then only thing you can do is make sure that Access 97 is up to date with all Service Packs.

Let's see if another Expert might have more insight...


JeffCoachman
0
 
LVL 39

Expert Comment

by:thenelson
ID: 24396545
You are describing the infamous Access 2002+ and Vista security pain in the butt problem. What MS says about why they have decided to make our life miserable and how to deal with it:
http://office.microsoft.com/en-us/assistance/HA011225981033.aspx

Vista's increased security makes life even more fun by suppressing the "preceeding alert" so that we all can be totally confused.

Two ways to handle it for files used internally:
The safer way: Use SelfCert.exe http://support.microsoft.com/kb/q217221/
The easier way: Tools > macros > security level low (won't work with Vista)

The only way to handle it if you are publishing your software is to buy an certificate. The least expensive certificate I have found is $99/year, $179/2 years at:
http://www.instantssl.com/code-signing/code-signing.html?currency=USD®ion=North%20America&country=US

Frequently asked questions about Access security warnings:
http://office.microsoft.com/en-us/assistance/HA011225981033.aspx

How to certify can be found at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsigningvbaproject.asp

Other places to buy a certificate:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsecure/html/rootcertprog.asp
0
 
LVL 39

Expert Comment

by:thenelson
ID: 24396551
BTW: Hi Jeff!
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24399365
Hey,

Nice of you to drop by and Bail me out.
;-)

Just to be sure, this is the Access 97 version of the message:
 "Outlook is trying to send email on your behalf..." message?

If s,o would CDO or Outlook Redemption be an option?

Jeff
0
 

Author Comment

by:Tomcpt
ID: 24399723
Jeff that is my guess too. The files are not availabale for vista and mail. I will keep looking for a solution on the web. Thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24399885
OK
keep us posted
0
 

Author Closing Comment

by:Tomcpt
ID: 31581553
The setup cannot be done with Vista Microsoft Mail. Thanks for everyone's help.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
One-stop solution for Exchange Administrators to address all MS Exchange Server issues, which is known by the name of Stellar Exchange Toolkit.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

649 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