Emailing forms/queries/reports

  • Thread starter Thread starter jwr
  • Start date Start date
J

jwr

I have need to email each of these access projects, allow the recipient to
add some information, and then transmit same back to me.

What is the best way to do this?

Thank you
 
E-mail is rarely a good solution for this sort of interaction with an Access
database.
If all of your recipients are on your local network, a server-based MDB/MDE
file might provide a good solution.
Otherwise, you might look into an Internet-based solution.

HTH
 
You can e-mail data from an Access database in a number of formats,
including Excel.
However, if your users are going to alter the data and return it to you,
you're opening yourself to a wide range of issues when you try to import the
data back into Access, as Excel (and other options) permit re-arranging data
and don't provide the validation Access does.

For a simple example, suppose you have a date/time field for "ProjectDue".
In Excel, your recipient types in "sometime next week". This is valid in
Excel, but you'll need manual intervention to get any meaningful data into
Access from that.
 
If you have a Terminal Server set up, use that.
This doesn't sound like the size of project which would probably justify
setting up a TS just for that.

Other than that, while you can use a Jet data engine for data storage (the
engine used by Access), you'll be better off with a non-Access technology
for the front end. The choice lies largely with the skills of the
programmer - PHP, classic ASP, ASP.NET are some options.
 
Back
Top