Error Emailing query in Macro

K

KLang

A coworker and I have had a similar issue and are curious
if there is any kind of fix. We both have all updates
installed on our machines, so we know its not a missing
service pack. While running a macro, we use a SendObject
action to email a query. It repeats this process several
times to email different queries. What looks to be
completely at random, we both get the Access error that
forces Access to close out, backup, and repair. I was
able to rerun the process, with no problem. My coworker
tried the same thing, but it kept killing Access. After
trying 3 or 4 times, it finally worked. We're working in
Access 2003 databases linked to a SQL Server backend.
Anyone have any solutions/answers?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top