Emails alerts from back end

Hi Rico,

Were you able to solve the situation...and if its not too much trouble can
you explain to me what you did, because I am in the same situation and do not
really know that much about access. But, I have developed a database that
just needs to check the dates of when the contract was signed and send out
alerts either by email or through screen popups every 6, 18, and 36 months.

Thanks for you help in advance,

Mikhail

"rico" wrote:

Thanks Douglas,

yea it makes no sense to me now you mention it, i think you've helped me
break my mental block on this problem tho, i have a few ideas now. Thanks
again

Rico

"Douglas J Steele" wrote:

"have the back end open all the time on the server" doesn't really make
sense in terms of how Access works.

Access isn't a server-based application: realistically, all you're doing is
storing a file on the server, and connecting to that file from each of your
front-ends.

You need some way of opening an application that runs code on a regular
basis to see whether there's data in the back end that needs to be reacted
to. This can be a front end on someone's desktop that's always open.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"rico" wrote in message
...
Hi to all!

I've built a front end/back end batabase for our small company (10 users).
It handles goods in out, works orders, etc. I'm now looking to set up an
alerts system that emails users when eg: a works order is due.

The only way i can think to do this is to have the back end open all the
time on the server and running loops to check for the dates and times of
certain entrys, then send emails from the server accordingly.

This seems like a messy way to do things. Has any one got any onther
solutions? Maybe there is some third party software to link between the
backend and the servers email?

TIA

Rico