MS Access 2003 and Outlook 2003/Website

[James_Richards]

I'm working with someone developing a website for our company, and had some
questions. I've read alot of resources and articles on how to integraste
these thigns, but can't seem to get to the right spot.

What we want to do, is have a webpage, that a customer can access, fill out
a small form for RMA requests, then either email that to a specific email
address which would be filtered to a folde rin outlook, and then have the
Access database look in that folder for new emails and add that info in to
the db. I have that part partially figured out, but another option we were
looking at is having a form on the webpage, just enter that information in
directly. Alot of the info on the net is for 2007 versions and not for 2003.
Is it possible to do what we're trying to do? Or do we need to upgrade to
the next version of office?

Any links to resources would be greatly appreciated, or if someone has done
this before, maybe post what you did and how you did it.

James Richards
IT Dept @ www.imageWest.tv
702-233-0076
800-673-8076
Las Vegas, NV

 

[James A. Fortune]

I'm working with someone developing a website for our company, and had some
questions. I've read alot of resources and articles on how to integraste
these thigns, but can't seem to get to the right spot.

What we want to do, is have a webpage, that a customer can access, fill out
a small form for RMA requests, then either email that to a specific email
address which would be filtered to a folde rin outlook, and then have the
Access database look in that folder for new emails and add that info in to
the db. I have that part partially figured out, but another option we were
looking at is having a form on the webpage, just enter that information in
directly. Alot of the info on the net is for 2007 versions and not for 2003.
Is it possible to do what we're trying to do? Or do we need to upgrade to
the next version of office?

Any links to resources would be greatly appreciated, or if someone has done
this before, maybe post what you did and how you did it.

James Richards
IT Dept @ www.imageWest.tv
702-233-0076
800-673-8076
Las Vegas, NV

Access 2007 has an option to integrate email data with a database.
Classic ASP or ASP.NET can allow direct changes to SQL Server data.
Another possibility is to Spry-enable the website so that it uses XML
for its data store, which can then be imported into Access.

How do I collect data via email for a specific record in a table, using
Access 2007?:

http://groups.google.com/group/microsoft.public.access/browse_frm/thread/7c0be8eb1126994e

Differences between ASP and ASP.NET:

http://www.w3schools.com/aspnet/aspnet_vsasp.asp

"Spry helps Web designers incorporate XML data into HTML documents with
a minimal amount of JavaScript." from:

http://www.devxnews.com/article.php/3613311

James A. Fortune
(e-mail address removed)