Email Notification

  • Thread starter Thread starter DFG
  • Start date Start date
D

DFG

Is there a way that access can notify me of a change to the data base via
email? Basically I am trying to streamline the interation that I have with a
database. I am the owner and have to check the data base every day, however,
the data base is not changed every day, just once in a while. It would be
useful if it could email me upon a change. Is there a way?
 
DFG said:
Is there a way that access can notify me of a change to the data base via
email? Basically I am trying to streamline the interation that I have
with a
database. I am the owner and have to check the data base every day,
however,
the data base is not changed every day, just once in a while. It would be
useful if it could email me upon a change. Is there a way?
Click to expand...


If all updates to the data will be done by forms in the database, then you
can have code that in the forms' AfterUpdate and AfterDelConfirm events that
send you an e-mail using the DoCmd.SendObject method. If the database could
be updated by any other means, though, the only thing I can think of is to
have a task that runs all the time and periodically checks the database for
changes (maybe by looking in tables for last-updated fields, maybe just by
checking the last-modified date of the file).
 
Back
Top