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

Access 2007 on WinServ2008Standard - SendObject comes up with allow/deny

Access 2003 (MDB) database using SendObject command.  Works fine on an old XP box running Office 2003 apps and ClickYes, connecting to Exchange Server 2007.

Moving apps to a new box running Windows Server 2008 Standard and Office 2007.
SendObject command keeps popping up with the "allow/deny" sending of the e-mail message.  Have set up Trust Center in Access/Outlook to allow macros, programmatic access, etc....still doesn't work.  

Any suggestions on how to eliminate that allow/deny popup?
  • 4
2 Solutions
It is Outlook Security...

Try an app like MapiLabs

ParisBPAuthor Commented:
Thanks for the suggestion.  I installed their Advanced Security for Outlook yesterday even though WinServ2008Standard is not listed in their system requirements...did not work.  When trying to run the task (WinServ task scheduler, calls the Access macro via commandline switches) *OR* manually executing the macro in Access itself, I never received a prompt from the MAPILab application to set the allow/deny access value as indicated in the small graphic at the top of that webpage.

Sidenote - within Outlook 2007's Programmatic Access, message appears as "Antivirus status:  unavailable.  This version of Windows does not support antivirus detection".  We're running Symantec Enpoint Protection and the machine is considered isolated...so punching holes in the registry to get the messages out is certainly an acceptable option.  Tried a couple of entries that I saw elsewhere, but they didn't work either (to reg key location HKLM/SOFTWARE/Microsoft/Office/12.0/Outlook/...)

Another option (?) - uninstall Outlook 2007 and install Outlook 2003...don't know about potential for version conflicts...
If you can upgrade to Access 2007 you can use the "CreateObject("Outlook.Application")" and it bypasses the Outlook "allow/deny popup".

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.

ParisBPAuthor Commented:
We're using Access/Outlook 2007 already...running on WinServ2008Standard.  Connecting to Exchange Server 2007.  All of our automation is running straight off pure Access macros...no VBA.  Outlook is open/minimized at all times.  I threw out the idea of switching Outlook back to 2003 if there were no complications.  Just throwing ideas at the wall now, trying to see what'll stick.  Thanks for the response.
ParisBPAuthor Commented:
Have also tried making registry changes as suggested on Microsoft site for
[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Outlook\Security] and DWORDS (value 2 for autoapprove) on PromptSimpleMAPISend, PromptSimpleMAPINameResolve and PromptSimpleMAPIOpenMessage.

As mentioned above, we are on Access/Outlook 2007 (32 bit, connecting to Exchange Server 2007) and Windows Server 2008 Standard (64 bit).

Running out of guesses and time...
ParisBPAuthor Commented:
Opted to go with ClickYes Pro...seems to work fine for what we're looking to do.  
Thanks to those who responded.
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

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.

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