Auto Alert Mgrs when changes/additions made

[AC5FF]

I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.

The question I have is there a way for Access to send me a notification that someone has requested the change?

I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...

I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.

Any suggestions?

 

[jdraw]

How about they fill in a form that actually updates a Table of Pending Address changes with their name, date..... whatever. Something you could query on a frequent basis and take the appropriate action. For audit logging purposes you could have a flag in that table to be filled by you once the change has been made or you've made a decision not to change the value. No email required-- but it assumes you and they have access to the database. If daily is too frequent, how about once a week.
Just some thoughts.

 

[AC5FF]

jdraw;
Thanks.. The way you are describing things is just how I have it set up now. I have to log in daily/whatever to check for new requests.

While this works (I've got reports/etc that run when I log in) the problem I run into is I seem to be away from my desk more and more lately. I barely have time to keep up with my normal tasks; let alone adding another. 95% of the time I will check this my reports will be blank. It'll be a rare occasion when someone enters a request. That will lead to complacency on my end I'm sure.

If I came back to my desk and saw a message on my screen that said a change had been requested, it would at least put checking this DB towards the top of my to-do list.