e-mailing when new record appears in linked data base

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a linked data base that is updated when certain criteria are met in a
primary data base. I'd like to be able to send an e-mail to someone if a new
record pops into the linked data base. Is this possible and how?
 
Sorry, no it's not possible.

It's possible to insert rows into that linked database through a number of
different means. Access is simple a file-based application: it doesn't
provide triggers, like server-based DBMS (such as SQL Server and Oracle)
provide.
 
Not directly possible, as there are no triggers in Access. But you can make
sending an email part of the process of entering the new record. You can
also use a form to poll the table every minute or so and check its
recordcount. If you are using a sequential autonumber, you can tell which
records were added and email information based on them.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Back
Top