E-mailing a single record from a shared database

  • Thread starter Thread starter Cheri Terrell
  • Start date Start date
C

Cheri Terrell

I am creating a database that will be shared on the
intranet. The end user will be filling out forms, and the
information that THEY generate, needs to be e-mailed to
two seperate people.

(Only the information that the end-user is creating needs
to be sent to the support people.)

I have never posted to a web page and I alson do not know
how to send only the data the customers is creating to the
support team. I would greatly appreciate some insight and
suggestions.

Thank You
Cheri Terrell
 
You have multiple options for using an Access database on an intranet, and
your brief description sounds as if most any of them might be adequate:

(1) Microsoft Front Page 2002 with the Database Interaction Wizard will
allow you to create Forms for entry of data and storing in a database. You
will have to write some ActiveServerPages, or find a component, for creating
an e-mail to send the information.
(2) Access' Data Access Pages (provided all your users are running Windows
and using IE 5.5 or later) will let you do the same thing, but allows
somewhat more complex operations.

NOTE: in either case, it might be simpler for the support team to
periodically check the database, at their own convenience, rather than
_send_ the data to them.

(3) Create a custom intranet application, using classic ActiveX Server
Pages, .asp, or the newer ASP.NET. This will be more effort, and, from your
description, you may not need the flexibility that it provides (at the cost
of more complexity). On the other hand, you might take a look at Microsoft's
site for the freely downloadable "Web Matrix" product for creating an
ASP.NET database application -- that would be a good deal easier than
creating asp pages from scratch.

Good luck with your project.

Please follow up here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
Back
Top