A web site I have created allows visitors to place adverts. Registered
users may subscribe to these adverts, receiving a copy of new postings by
e-mail.
So the (simplified) scenario is
- visitor fills in a form with advert details
- the form is submitted
- the advert details are placed in an (Access) database
- a query is used to retrieve the names and e-mail addresses of all
subscribers
- the advert is send to each subscriber (loop) using CDONTS
- the visitor is redirected to a "success" page
The sending of the e-mail messages is taking some time, so visitors can
think something has gone wrong, then try submitting again, go away, etc.,
etc.
Is there a way for the form processing ASP page to initiate some sort of
background task which sends the e-mail messages, so that the visitor sees
the "success" page quickly, and does not have to wait for the e-mails to
be sent?
The site is hosted, so I don't have the ability to install any custom
components, etc. However, I can use Access database(s). Could I do
something with an Access module and run it from a macro/query?
TIA
Doug