A "push" function to produce an email on an event

Someone has asked me to create a database and include what they call a "push"
function that will automatically create an email to warn that a contract
renewal date is imminent. I believe that this can't be done in a desktop
application because although I can see how I can create the alert by running
a query against date parametrs, it still needs a trigger which I'm assuming
would be someone clicking a control button to run the query. I'm assuming
that what they want could only be achieved by creating the database on a
server and running a task say over night. I suppose one way would be to run
a query when the the Access application is opened? Am I right?
Tony

--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1