access automation

  stevedunham 02:40 30 Sep 2005

I use an MS Access 2003 database which is sited on a server some miles away from my office and wonder if it possible to automate the database. The dbase consists of a names and dates indicating when they have to have completed something.
is it possible to set things up so that that access notifies me that these people have to complete the designated updates.
eg say 40 names need to update in October, access tells me the names i need in advance. I know a queery will do this but I would like to do this automatically so that I don't forget myself, something like a desktop alert.
Any suggestions most welcome

  Yoda Knight 10:00 30 Sep 2005

Try Windows scripting or Scriptit programs.

  stevedunham 23:53 30 Sep 2005

Sorry Yoda knight but that means nothing to me can you enlighten me?

  Access genu 06:34 01 Oct 2005

yuo could create a VB program to to this and then run this as a job on the server

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?