• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Send to option Greyed in Access 2003.

When my client attempts to send a report to email using Access 2003, the option is greyed out and they therefore are unable to complete the action. I feel the fault lies with compatibility, as we use Office 2010 for the rest of daily use, such as Outlook for email. Access 2003 is used just for their database. But I have two other servers with identical images installed, and they both allow send to email.

I am at a loss as to what could be preventing send to email. I look forward to hearing your thoughts that could help me find what is causing the issue.
0
dcleaver
Asked:
dcleaver
  • 4
  • 4
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
See here perhaps:
https://www.experts-exchange.com/questions/28172411/Can't-export-to-email-from-Access-2010.html

Remember that Access 2003 is 14 year old technology.
At some point you will start to see too many comparability issues.

Suggest upgrading to at least Access 2007, where the .accdb format was introduced.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Change:
At some point you will start to see too many comparability issues.
to:
At some point you will start to see too many compatibility issues.
0
 
LBTechSolOperations DirectorCommented:
I have seen something like this before and for us and it turned out to be permissions for the access 2003 to be allowed to send via outlook 2010, usually you get a popup asking if you would like to allow the application...

This Link may open your outlook client a little too much Outlook Settings
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
Jeffrey CoachmanMIS LiasonCommented:
Or try using a code based solution
DoCmd.SendObject acSendReport, "YourReportName", acFormatPDF, "DestinataionEmailAddress", , , "YourSubject"
(If you have the PDF add in installed)
or
DoCmd.SendObject acSendReport, "YourReportName", acFormatRTF, "DestinataionEmailAddress", , , "YourSubject"
(Can be read by MS Word)
or
DoCmd.SendObject acSendReport, "YourReportName", acFormatHTML, "DestinataionEmailAddress", , , "YourSubject"
(Can be viewed in any web browser)

There are other export formats available as well, ...depending on your needs
0
 
dcleaverAuthor Commented:
Hi Jeffrey,

Believe me, we have been trying to get this updated, but the consultant that creates and manages the database just refuses to update it, so sadly got work with whats available. I expect its compatibility causing the issue, but as I said the other two servers work correctly, and they are pretty much identical in every way. I will try and have a look at your other suggestion though, as I haven't tried that and could help.

LBTech, doesn't look the reg keys are there, so may add them and see if that does anything, Many thanks.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Believe me, we have been trying to get this updated, but the consultant that creates and manages the database just refuses to update it, so sadly got work with whats available.
...I hear you...

What's odd is that usually this situation is reversed, ...
Typically the consultant will have the latest/greatest version of Access, ...and it will be the client not wanting to upgrade...
;-)

What is doubly odd is that the consultant should be the one researching this issue, ...not you.
:-O

In any event, ...keep us posted...

JeffCoachman
0
 
dcleaverAuthor Commented:
Yeah I know right, this one definitely switches the stereotype :-)

And believe me, I've already has this conversation with him, just yesterday being one of the times! Gonna boot a backup of the server in VM so I can test without affecting users. Will update with my findings.
0
 
dcleaverAuthor Commented:
Technician before my time had changed Office to 64-bit rather than 32-bit. Therefore Access 2003 wasn't compatible with it. Unsure how its working on the other two servers, as they both have 64-bit Office installed, but at least I have a solution.

Thanks for all your help.
0
 
dcleaverAuthor Commented:
Troubleshooting performed found the issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now