?
Solved

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

Posted on 2009-05-14
7
Medium Priority
?
588 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
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 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