From: Rick A.B. on
Just thought I'd share this in case anyone else encounters this
problem some day. I have a database that's been in use for 6 years,
the last 2 in Access 2007. We use Groupwise for mail and I've used
the sendobject command to successfully send out email's with
attachments. Last week the sendobject command quit working. No error
message, nothing. I stepped through the code and it would excecute
the sendobject command with no errors but not send the email. I
checked everything, reverted to an older copy of the front end still
would not work. I finally ran the microsoft office diagnostics and it
found one error and repaired it. It wouldn't tell me what the error
was but it fixed the problem and the sendobject now works. It would
have been nice of the diagnostics had given me a little more
information but I guess that's too much to hope for in this age of
idiot proof software.

Rick
From: Arvin Meyer on
My guess is that it wasn't an Access error, but a Windows one. If you had
Visual Studio or C++ installed, you might be able to intercept the messages
to the OS.

As it is, be thankful that the problem is solved, and don'y pay attemtion to
the man behind the curtain.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


"Rick A.B." <rick.bresin(a)minneapolis.edu> wrote in message
news:693b157f-932c-45ee-8f49-fd0833ddf689(a)q12g2000yqj.googlegroups.com...
> Just thought I'd share this in case anyone else encounters this
> problem some day. I have a database that's been in use for 6 years,
> the last 2 in Access 2007. We use Groupwise for mail and I've used
> the sendobject command to successfully send out email's with
> attachments. Last week the sendobject command quit working. No error
> message, nothing. I stepped through the code and it would excecute
> the sendobject command with no errors but not send the email. I
> checked everything, reverted to an older copy of the front end still
> would not work. I finally ran the microsoft office diagnostics and it
> found one error and repaired it. It wouldn't tell me what the error
> was but it fixed the problem and the sendobject now works. It would
> have been nice of the diagnostics had given me a little more
> information but I guess that's too much to hope for in this age of
> idiot proof software.
>
> Rick


From: Tony Toews on
On Thu, 1 Jul 2010 07:19:51 -0700 (PDT), "Rick A.B."
<rick.bresin(a)minneapolis.edu> wrote:

>Just thought I'd share this in case anyone else encounters this
>problem some day. I have a database that's been in use for 6 years,
>the last 2 in Access 2007. We use Groupwise for mail and I've used
>the sendobject command to successfully send out email's with
>attachments. Last week the sendobject command quit working. No error
>message, nothing. I stepped through the code and it would excecute
>the sendobject command with no errors but not send the email. I
>checked everything, reverted to an older copy of the front end still
>would not work. I finally ran the microsoft office diagnostics and it
>found one error and repaired it. It wouldn't tell me what the error
>was but it fixed the problem and the sendobject now works. It would
>have been nice of the diagnostics had given me a little more
>information but I guess that's too much to hope for in this age of
>idiot proof software.

Thanks for your posting. I forget about the Microsoft Office
Diagnostics tool on the menu.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
From: Tony Toews on
On Thu, 1 Jul 2010 07:19:51 -0700 (PDT), "Rick A.B."
<rick.bresin(a)minneapolis.edu> wrote:

>Just thought I'd share this in case anyone else encounters this
>problem some day.

I also decided to blog it at
http://msmvps.com/blogs/access/archive/2010/07/01/microsoft-office-diagnostics-fixed-sendobject-stopped-responding.aspx

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/