Email notifications of database updates

B

Barbara

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!
 
R

Rick Brandt

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!
Click to expand...

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.
 
B

Barbara

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!
 
R

Rick Brandt

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!
Click to expand...

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