Emails

He has: 183 posts

Joined: Nov 2003

Is there a way of getting an email sent when a user has added a new record in an access database using ASP? Confused

They have: 461 posts

Joined: Jul 2003

dos runs? since when? oh, you mean OLD DOS, pre-gates buy-out!!!

erm, back on topic, is this to the user editing or to some other user? my guess is that it would be possible, but to help you figure out how to check on that, you will need to give us more info i think

POSIX. because a stable os that doesn't have memory leaks and isn't buggy is always good.

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

If the changes to the access database are being performed via an ASP page, it is simple enough to add an email routine.

If the changes to the access database are being performed directly to the database (via runing the *.mdb in windows), I don't know of any ways to add a trigger to the database. The only possible (or not, I've never tried) solution I can see here is using a form within access to make the changes and adding VBA to the backend of the form to send an email.

Mark Hensler
If there is no answer on Google, then there is no question.

druagord's picture

He has: 335 posts

Joined: May 2003

To send mail via ASP you need to build a system or buy one. ASPmail wich can be found at aspmail.com work very well for in the days i was stuck n MS server

IF , ELSE , WHILE isn't that what life is all about

They have: 12 posts

Joined: Feb 2004

Surely the hosting service will have an email system set up already?

If using ASP then once a new record is added you can easily intercept the relevant data and have it sent to you via email.

Find your Old Flames at MyOldFlames.com

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.