AfterInsert on a table

[Guest]

I interfaced my MS Access 2003 DB to ASP. When the user clicks on SUBMIT and
a new record is added to the main table, I'd like to fire an email from MS
Access to inform me that a new record has been added and update the status of
that record from T=Transmitted to R=Received

When I was using the Form(s), I had a macro that was taking care of it
(Private Sub Form_AfterInsert()...).

Is there a way to write a similar code for any record added to the table
from an ASP application?

Thanks for your precious help

 

[Brendan Reynolds]

Not in Access, no. 'Events' that are fired when data changes in a table and
are not dependent on user interface objects such as forms are known as
'triggers', and they are a feature of server database engines such as SQL
Server or Oracle, not file-server database engines like the JET database
engine that is used when you store your data in Access MDB files.

You will need to handle the sending of the e-mail in your ASP pages rather
than in the database.

 

[Guest]

Brendan,
Thx for your reply. I believe we will convert the db into sql server,
eventually. In the meantime I will try to find some ASP code to handle it.

Thanks again for your precious help.

Rick