How do you automate Access to send an e-mail when a tables field is updated?

[Kerry Archer]

I have an Access Database that updates the staff status while they are at work. The table is updated with an active server page, that updates the fields. I would like to know if there is a way to e-mail the group when a staffs status changes? I just want it to include information from other fields in the table, including First Name, Last Name, Status and Comments.

[evildracko]

updated using queryies or in the table themselves?

[Kerry Archer]

The information is all listed on an internet page. The users click their button, which takes the to the active server page. This gives them the opportunity to select in or out and leave a comment. When they submit, it updates the database fields and in turn updates the web page which pulls the information from the database.

[Steven Kogan]

It sounds like you want to trigger an event when data changes, even though the change is made on an active server page instead of from within Access.

You may be able to get that sort of functionality using built-in features of Access 2010 using Access Macros and SharePoint 2010. That's probably not your case.

SQL Server also has trigger events. Upsizing Access data to SQL Server isn't that difficult, but you'd want to have a SQL Server expert available for administration.

With MS Access itself you could rig up a system where if the status is changed a flag is set indicating a change was made but the email is not sent. Then you could run a query and vba code, perhaps launched from a form timer event, to see if any emails need to be sent and if so, to send the emails.

To send the emails automatically without warning messages you could use CDO. There is a thread for that at http://bytes.com/topic/access/answer...ail-cdo-access