e-mailing when new record appears in linked data base

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?
 
D

Douglas J. Steele

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.
 
A

Arvin Meyer [MVP]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pop-up form that creates record that links 1:1 to main form 0
Linking data bases in Access 2003 2
Macro for Sharepoint List and another Table?? Same # records? 1
How do I do an e-mail merge? 1
Group E-mailing 6
Autopopulate a Field in a New Record Based on a Field in a Prev Re 1
Using a form created in Access to collect data and import 4
Append only new records with an append Query 1

Top