Hi. I have searched for something similar, but have not found any similar situation and I know somebody has done this before. Here it goes.
I have an Access application written with extensive VBA code behind every form. I have a WIndows 2000 Adv Server network with database split FE / BE. I need to be able to send out an email from Access once certain criterias are met. I figured out how to email from VBA onto Outlook.
But I do not want to send the email from the workstation, but instead from the server where the back end resides. How is this possible in Access? What do I need to trigger a response from the back end, and send an email from the server? I think this would be possible with SQL server by using triggers. When a table is updated, I could run the email code.
I really wish to keep Access for a little longer. I do plan on upgrading to a client server database, but for now, can anyone give me some hints or ideas? Maybe I could wait until the end of the day, and send emails at the end of the day. But how can I make the server accomplish these tasks from Access at certain times or at certain conditions?
Thanks alot
I have an Access application written with extensive VBA code behind every form. I have a WIndows 2000 Adv Server network with database split FE / BE. I need to be able to send out an email from Access once certain criterias are met. I figured out how to email from VBA onto Outlook.
But I do not want to send the email from the workstation, but instead from the server where the back end resides. How is this possible in Access? What do I need to trigger a response from the back end, and send an email from the server? I think this would be possible with SQL server by using triggers. When a table is updated, I could run the email code.
I really wish to keep Access for a little longer. I do plan on upgrading to a client server database, but for now, can anyone give me some hints or ideas? Maybe I could wait until the end of the day, and send emails at the end of the day. But how can I make the server accomplish these tasks from Access at certain times or at certain conditions?
Thanks alot