Discussion:
"Operation Cancel by User"
(too old to reply)
Ross
15 years ago
Permalink
I have a program that pulls data from External datasource. One of the
users/Tester began the pull in MS Access 2007 (office 2007). She then went
into MS Outlook - emails and opens emails one at a time, reads it, and then
she HITS "ESC" to close the current email.

When she hits "ESCAPE" in Outlook, MS Access stop running and says

"Run Time Error 3059"
"Operation canceled by user."

How do I prevent Outlook from Cancel MS Access Operations?

Thank you

Ross
Paul Shapiro
15 years ago
Permalink
While I wasn't there so I can't be sure, I would guess that Access had the
focus when she hit the <Esc> key. Maybe she pressed <Esc> twice? Unless the
Outlook application is running code to control the Access application, I
don't know of any way for Outlook to affect Access unless it crashes and
takes the computer down with it. However, having said that I also didn't
know that the <Esc> key would close an Outlook message, but sure enough, it
does.
Post by Ross
I have a program that pulls data from External datasource. One of the
users/Tester began the pull in MS Access 2007 (office 2007). She then went
into MS Outlook - emails and opens emails one at a time, reads it, and then
she HITS "ESC" to close the current email.
When she hits "ESCAPE" in Outlook, MS Access stop running and says
"Run Time Error 3059"
"Operation canceled by user."
How do I prevent Outlook from Cancel MS Access Operations?
Arvin Meyer [MVP]
15 years ago
Permalink
There is no direct connection between Access and Outlook unless Outlook is
being run through Access automation or visa-versa. I just tested and cannot
reproduce the behavior she experienced. One other possibility is that a
database is being opened as an attachment, or through an attached shortcut.
There's no way to determine with certainty what will happen.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Post by Ross
I have a program that pulls data from External datasource. One of the
users/Tester began the pull in MS Access 2007 (office 2007). She then went
into MS Outlook - emails and opens emails one at a time, reads it, and then
she HITS "ESC" to close the current email.
When she hits "ESCAPE" in Outlook, MS Access stop running and says
"Run Time Error 3059"
"Operation canceled by user."
How do I prevent Outlook from Cancel MS Access Operations?
Thank you
Ross
Loading...