Create email trigger

[ProxyPr]

I have an access database where users register. I have set up my site so that
I need to activate their accounts before they can get access. problem is I
have to keep checking the db to see if there are new entries. How can I
create an email trigger to send me a mail when someone registers. Thanx
ProxyPr.

 

[Duane Hookom]

There are not "triggers" in Access. You could add code to the On Insert
event of a form but it sounds like you are adding records via a web "site".

You could possibly add a yes/no field to your table "IsNew" and set the
default to True. You could then search for all the true records to send an
email and then set all values to False.