I created a database in Access 97 to register participants for classes. The database (via VBA) parses any number of requests for registration, validates space is available in the desired class and registers the participants. Once the person is registered for a class, the database automatically emails the participant a confirmation using the following statement
' Send the email
DoCmd.SendObject acSendNoObject, , , Email, , , eSubject, eBody, False
where "email" is the email address, eSubject is a string with the email subject line and eBody is a string with the email message itself.
This worked great under Access 97, but when the database was converted to Access 2000, the confirmation is only sent to the first participant processed. The database must be closed and reopened to send the next email.
Any idea what can be done to fix this?