From: Rick A.B. on 1 Jul 2010 10:19 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 1 Jul 2010 14:04 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 1 Jul 2010 17:16 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 1 Jul 2010 18:50 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/
|
Pages: 1 Prev: Create AccDE from AccDb Next: Source code browser for VBA |