Microsoft Access can not send emails after security updates applied.
I updated to office 2010 on server 2012R2. After running all Microsoft updates, Microsoft Access will no longer send emails.
Error: "Microsoft Access can't send a message for the reason stated in the preceding alert. ... Before attempting to send an e-mail message from Microsoft Office Access, resolve the problem identified in the previous message, or configure your computer to send and receive e-mail messages".
Using the "Email Database Object" to send a query. Ran perfectly for years prior to update.
Make sure you update to the fixed build, try again and let us know if that took care of it, and if not, if there are any other messages.
Jim.
John Tsioumpris
What method you use to send email ?
Outlook or some .dll.
Mark Drelinger
ASKER
I use a macro and the sendemailobject method.
All seemed perfect until a large batch of windows updates were run.
The server does have outlook loaded on it, so I assume the macro sends via outlook.
Both avoid the security dialogs when sending e-mail in code.
Jim
John Tsioumpris
For years i have used CDO...take a look here for a tutorial
Dale Fye
Mark,
I'm guessing that somewhere in your code or macro you are attempting to perform an UPDATE query, but have used SetWarnings False prior to calling that line of code. I found this in one of my clients applications. Syntax looked like:
Docmd.SetWarnings False
Docmd.OpenQuery "QueryName" 'this is an update query
docmd.setWarnings True
Because they had SetWarnings False, the error message associated with the links that Jim and John referenced are hidden from you. Check the macro and see if you have this type of syntax. If so, look at the link that JIm gave you to resolve this problem.
Hello team. I appreciate your responses.
i've worked through each of these suggestions, but no success yet.
I'm happy to do a 3rd party app, but I reached out to them with the error and they did not think it was something that would be corrected with their software.
Dale, the macros only send a query (no updates) that give the error - screen shots below.
Some old solutions show that it might be an old (circa 2012) issue from Microsoft but their hot fixes were removed. Seems that "EmailDatabaseObject" may no longer work after applying some old windows updates. Capture.PNG Capture1.JPG
Jim Dettman (EE MVE)
I'm happy to do a 3rd party app, but I reached out to them with the error and they did not think it was something that would be corrected with their software.
I'm not sure why not. What changed in Office 2010 is the Outlook security model. Now it's not possible to get around certain things when you work in code (Macro or VBA). vbMAPI is a try before you buy, so you can download it and give it a go.
But with that said, on this:
Ran perfectly for years prior to update.
are you saying it was an Office update for 2010 that caused the problem, or that you just updated to Office 2010 from a prior version?
Jim.
Mark Drelinger
ASKER
Hi Jim - thanks for the response.
I sent them an email with the error, and they said they were not aware of that error, so they couldn't confirm it would fix it. They explained that their software would require changes to create the attachments as temp files, and then send those attachments within their program. So... that seemed ok, but likely not a fix to my issue.
I had office 2007 on this machine until last week. I upgraded to office 2010, and actually everything was fine even after rebooting. however, overnight, wsus sent down Office 2010 security patches, and that's when it failed. Thought I could just remove the security patches, but no go. Thought I could just roll back to Office 2007, but it actualy continues to apply those patches to Office 2007.
I do have a complete vm snapshot that I'm planning to roll back tonight. It's probably the cleanest solution at this point.
You should be able to roll back those update (uninstall them), and then should be able to configure Office not to install update except with your permission.
but your error message says: "Microsoft Access can't send a message for the reason stated in the preceding alert."
What was the reason stated in the "preceding alert"?
Mark Drelinger
ASKER
Thanks for all the assistance. Regards, Mark
Mark Drelinger
ASKER
no preceding alert - seems like an ambiguous message - checked the logs and nothing there.
Although the error message has not changed, I'm starting to wonder if my attempts to repair have compounded the issue.
The take way - don't upgrade office so close to retirement !
I just looked at my wsus server was set to "approve installation, but not approve un-installation. I'll change that and try again.
https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec
Make sure you update to the fixed build, try again and let us know if that took care of it, and if not, if there are any other messages.
Jim.