All,
I think I already partially know the answer here or atleast a solution to my problem but I want to be sure there is not an easier way and then secondly whether my "idea" is viable.
Firstly I use a data access page for users to submit a form to my database across our LAN. This is hosted on a normal server folder with a link to it placed on our intranet. I know I am unable to send an automatic email notification whenever this form is submitted (unless I dont mind users clicking an explorer security alert box, which I do mind =p). I am unable to use any cgi/perl/asp/other server side scripts to do this also (got to love corporate security).
So my only other way I can think of is trying to sort out automatic email notification from my back end/front end side, away from the online form.
Does anyone have any experiences of automated emailing? I basically want an email to be sent whenever a new record appears in my database that has been submitted from the web form (I will just flag an online form using a hidden textbox to segregate these from data submitted in the front end of my database).
I would ideally like this to happen without a front end to be open, however I am pretty much certain without some form of scheduler this would not be able to happen as access is not running.
So my only thought is to basically have the database open on mine, or someone elses system where a script will periodically check the database for new entries on the main table. Then I am pretty sure I can get some vba together to send an email through outlook or using MAPI.
Once again does anyone have any experience of doing this before I crack open my own plans? I am thinking a hidden form with a timer event to keep checking for new records.
Sorry for the long winded / vague post but as I said, I really think I know the answer is to use a timer..
I think I already partially know the answer here or atleast a solution to my problem but I want to be sure there is not an easier way and then secondly whether my "idea" is viable.
Firstly I use a data access page for users to submit a form to my database across our LAN. This is hosted on a normal server folder with a link to it placed on our intranet. I know I am unable to send an automatic email notification whenever this form is submitted (unless I dont mind users clicking an explorer security alert box, which I do mind =p). I am unable to use any cgi/perl/asp/other server side scripts to do this also (got to love corporate security).
So my only other way I can think of is trying to sort out automatic email notification from my back end/front end side, away from the online form.
Does anyone have any experiences of automated emailing? I basically want an email to be sent whenever a new record appears in my database that has been submitted from the web form (I will just flag an online form using a hidden textbox to segregate these from data submitted in the front end of my database).
I would ideally like this to happen without a front end to be open, however I am pretty much certain without some form of scheduler this would not be able to happen as access is not running.
So my only thought is to basically have the database open on mine, or someone elses system where a script will periodically check the database for new entries on the main table. Then I am pretty sure I can get some vba together to send an email through outlook or using MAPI.
Once again does anyone have any experience of doing this before I crack open my own plans? I am thinking a hidden form with a timer event to keep checking for new records.
Sorry for the long winded / vague post but as I said, I really think I know the answer is to use a timer..