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.
dcleaverAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dcleaverAuthor Commented:
Troubleshooting performed found the issue
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.