sometimes get msg: microsoft access has encountered a problem

[leahf via AccessMonster.com]

With a click of a command button, I send individual e-mails to a group of
people. Sometimes I will suddenly get the message: Microsoft Access has
encountered a problem...

I pressed the "send report" button based on suggestions that I saw in this
forum, but would like to know if Microsoft always responds, and, if so, how
long does it take to get a response? We don't want to transfer the
application to production until this problem is cleared up.

We have Access 2002. I never get the message when I print all the reports
instead of sending them by e-mail.

Thanks.
Leah

 

[Guest]

No. When you send them a report you are sending them info so that they can
investigate (if appliccable) and then try an resolve theses issues in future
releases of office/windows... They will not actually contact you. It is for
informational purposes only.

Most probably the issue lies with your e-mail code and it in turn is causing
your database to crash. If you are holding out on releasing the app until
this problem is resolved you'll need to fix it yourself or post your code
here and we can try and help you (but don't expect MS to be in touch to
resolve your individual problem - simply too many people and not enough
resources).

Daniel

 

[leahf via AccessMonster.com]

When I get to work tomorrow I will post the code, but if I remember correctly,
it's really just a DoCmd line. In either case, using the same population,
it will sometimes work and sometimes not, and when the error message occurs,
it doesn't always happen with the same person.

No. When you send them a report you are sending them info so that they can
investigate (if appliccable) and then try an resolve theses issues in future
releases of office/windows... They will not actually contact you. It is for
informational purposes only.

Most probably the issue lies with your e-mail code and it in turn is causing
your database to crash. If you are holding out on releasing the app until
this problem is resolved you'll need to fix it yourself or post your code
here and we can try and help you (but don't expect MS to be in touch to
resolve your individual problem - simply too many people and not enough
resources).

Daniel

With a click of a command button, I send individual e-mails to a group of
people. Sometimes I will suddenly get the message: Microsoft Access has

[quoted text clipped - 10 lines]

Thanks.
Leah

 

[leahf via AccessMonster.com]

This is the code that I use to send the e-mails. Right now I am sending them
all to my mailbox - which is not full, by the way.

DoCmd.SendObject acSendReport, stDocName, acFormatRTF, "xxxxx@xxxxx", , , Me.
ComboYear & " " & Me.comboMonth & "Monthly Report ", , False

I began with a group of 6 teachers. Sometimes it worked, sometimes not,
sometimes it stopped after the second teacher, sometimes the fourth...

I then used a group of over 60 teachers. The same thing. Sometimes it
worked, sometimes not, and when it didn't, the error message came up after a
different number of teachers.

When I get to work tomorrow I will post the code, but if I remember correctly,
it's really just a DoCmd line. In either case, using the same population,
it will sometimes work and sometimes not, and when the error message occurs,
it doesn't always happen with the same person.

No. When you send them a report you are sending them info so that they can
investigate (if appliccable) and then try an resolve theses issues in future

[quoted text clipped - 15 lines]