Database Change Alerts

[Joseph Liburd]

I have created an online IT Support database for my staff
and faculty members using Access 2002. My users are
submitting new trouble tickets via the intranet site front
end I created and everything is ticking away flawlessly.
The only thing is that I would like to be able to be
notified via email or a "net send" whenever a new
submission is created (new record in the database).... any
ideas? Please contact me @ (e-mail address removed).

 

[Sean]

I presume the back end is access.

The table has a unique key right?

It would be even better if the table had an auto incrementing field in it.

Then maybe some separate app or so could store the last used KEY and check
to see if there was one or more greater than that stored one.
This would run at a timed interval, if ya know what I mean. If it
checked every 1 min or 5 mins that might be alright, yeah????
It could senbd the email or net send.