Possible? MySql, Asp and MS Access

programming
1

Yo,
I’m not sure if this is possible, but here is what I would like to do. I have a MySql database linked with MS Access db for the purpose of using forms to input data. I would like to send an email any time I update or add an entry to the database.

This does not seem that difficult, but I can not figure out how to do it. The webservices I have available are ASP(not asp.net), MS Access and MySql. Thanks for any help, although I expect this problem to remain unsolved.

:slight_smile:

2

well it’s really a simple task, on the page where your inseting your data, send an email along using CDONTS.

here’s the code to send an email in ASP:


<% @language="VBSCRIPT" %> 
<%

Dim myMail, myBody

myBody = "Name: "& request.form("name") & vbcrlf
myBody = myBody & "Email: "& request.form("email") & vbcrlf
myBody = myBody & "Message: "& vbcrlf & request.form("message")

Set myMail = CreateObject("CDONTS.NewMail")

myMail.BodyFormat=1
myMail.MailFormat=1
myMail.From=request.form("email")
myMail.To=request.form("email")
myMail.Subject=request.form("subject")
myMail.Body=myBody
myMail.Send

set myMail=nothing

%>

btw it has nothing to do with databases unless you want to store the email addresses in there.