Notification of new entry

[Dave]

My IT guy tells me that this can't be done, but I'm
thinking he may just be lazy. We have Access 2000
(maybe '98) running on our web server. I created an Access
database to hold information gathered from a form. I would
rather not check the database regularly to see if anything
new has been entered, is there a way for Access to
notify/email me when a new entry is added into the
database? Thanks.

 

[Rick Brandt]

My IT guy tells me that this can't be done, but I'm
thinking he may just be lazy. We have Access 2000
(maybe '98) running on our web server. I created an Access
database to hold information gathered from a form. I would
rather not check the database regularly to see if anything
new has been entered, is there a way for Access to
notify/email me when a new entry is added into the
database? Thanks.

No. A server database that supported triggers could probably do this, but
Access/Jet doesn't have those. Whatever front end tool is being used to insert
the records would have to notify you in its program.

 

[Arvin Meyer]

My IT guy tells me that this can't be done, but I'm
thinking he may just be lazy. We have Access 2000
(maybe '98) running on our web server. I created an Access
database to hold information gathered from a form. I would
rather not check the database regularly to see if anything
new has been entered, is there a way for Access to
notify/email me when a new entry is added into the
database? Thanks.

Access can't do it from the tables as Rick mentioned because there are no
Triggers. However, IIS can do it when the data is sent to the database. You
can also have an Access (or VB) application running on a workstation that
checks the server database at regular intervals and sends an email if it
finds records since it last checked.

Both methods require some work.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access