access automation

  stevedunham 02:40 30 Sep 2005
Locked

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

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?