Updating Access 2007 database via email

[Satchel]

Hi...I'm a newbie when it comes to the net and working with databases.
I cut my teeth on Rbase for Dos, then moved to Foxpro 2 Dos then
Foxpro 2.1 for windows. Access of course is a new ball game for me
although I did use it in my work about 7 years ago simply by trial and
error.

I have the Office Enterprise Edition installed on my PC downstairs.
For some great reason, our M$ allows employees of our Corp. lets us
purchase the entire package for about twenty dollars.....not bad, so I
thought I would get it.

I have also subscribed to Office Live Essentials and created a crude
web site with a place for visitors to enter their contact information;
click the send button and zip me an email.

I have been told that Outlook 2007 can process this information either
static or live. Has anyone tried this feature? Anyone want to give it
a try (with bogus info.). I am also interested in how many
connections Office Live Essentials will simultaneously allow.



Below is what a MVP had to say about the process.
along with some blogs.

Thanks.
-----------------------------------------------
Copyright Ed Rucker at
http://blogs.msdn.com/access/archive/2006/06/30/652837.aspx
"Data Collection Through Email

One of the coolest new features in Access 2007 is the ability to
gather data through emailed forms. These forms can be used to either
update existing data or to gather new data. The forms can either be
rich InfoPath forms that show up in-place in Outlook 2007 email
messages, or they can be very simple HTML forms that can be completed
by users of practically any email client. When the forms are returned
to your machine, the data is extracted from the email message (either
automatically or manually at your discretion) and uploaded to the
database. In fact the data can even be linked to any linked table in
Access, so can be stored in SharePoint or even SQL Server if you'd
like. Data Collection is a very handy way to do a variety of things,
from gathering simple data (e.g. what are you bringing to the pot
luck) to periodically updating more complex data (e.g. annual updates
to customer contact information)."

 

[Guest]

Satchel,

If you search the blog in the archives you'll see that there is also an
explanation of how to do this. The feature does work but I have to say that
I've only tries via Access and that works like a charm. Keep in mind that is
you use this option you are potentially making yourself a spam victim. Access
is telling you when you run trough the wizard by stating that information
might be potentially harmfull.

 

[Satchel]

Would you give me the url for the search suggestion?

"Spam victim".... ok, I was thinking about testing the simultaneous
connections the web site could handle.


On Thu, 26 Jul 2007 12:56:02 -0700, Maurice

|>Satchel,
|>
|>If you search the blog in the archives you'll see that there is also an
|>explanation of how to do this. The feature does work but I have to say that
|>I've only tries via Access and that works like a charm. Keep in mind that is
|>you use this option you are potentially making yourself a spam victim. Access
|>is telling you when you run trough the wizard by stating that information
|>might be potentially harmfull.