Email notifications of database updates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to set up my Access 2003 database to send me an email when
any other user updates a form or table? Any help would be appreciated!
 
Barbara said:
Is there any way to set up my Access 2003 database to send me an
email when any other user updates a form or table? Any help would be
appreciated!

If they do all data edits via a form then those forms can have code to do so.
If they are also allowed to make design changes to forms then no to that.
 
They are only allowed to add/edit data. Can you point me in the right
direction regarding the code that would generate the email? Thanks very much!
 
Barbara said:
They are only allowed to add/edit data. Can you point me in the right
direction regarding the code that would generate the email? Thanks
very much!

Check the help file for the SendObject() function.
 
Back
Top