ASP / MS Access and Email Reminders

[bmd2k3]

Is there any way to set up an Access DB on the web and have email reminders sent out -- using CDONTs, ASPMail etc....automatically....without requiring someone to be logged into the client web interface ?

(or.....does this type of function really only exist in a true SQL db using stored procedures ?)


Thanks...
Brian

 

[sharedworld]

i don't think that on Ms access there is some stored procedures like you want, but you can use a much better solution which is to create a bat file (create a text file in notepad, and rename the extension to bat...) and write inside something like this
"start iexplore

http://www.mydomain.com/sendEmail.asp"

without the quotes, save it, and then make a scheduled task, available from the control panel, that should run this file whenever you need it, the asp page should send the email... the only thing you got with thois bat file, is the ability to run it when you want.

this is the best solution i found at this time, and I used it a lot to send email...

 

[sharedworld]

I found some other solution over there

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=139

if you like it better.