[AccessD] Web form data into Access97

John,
I am assuming an Access database.  I have had no trouble getting this type
of app to work with several commercial web hosts.  You are looking at Active
Server Pages (ASP) to "front" the database on the web in the form of a web
form.  I do most of my ASP programming (Vbscript) directly in Notepad, but
have also used FrontPage or Dreamweaver for the layout and then inserted the
ASP code into the resulting document -- then changed the file extension to
.ASP.

In short, it is definitely doable.  If it is a relatively small project and
you are good at self training, I'd take it on and force myself to learn ASP.
There are many good ASP devoted websites out there, and code for many basic
tasks is readily available.

ASP is certainly not the only approach, but it is one that I know works.

Good Luck and hope this helps.
Bob Ryan

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com]
Sent: Thursday, January 30, 2003 8:27 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Web form data into Access97


About two years ago, I wrote a program for our Tourism department that
tracks their 800 line requests. Their operators type information into
this program from phone calls, messages, and their web site. They do all
of this manually, which makes sense for the phone calls, but it seems
that there should be a way to replace Email with a web form, and have
that information piped into the program...I'll stop short of saying I
know there is, because I have absolutely no experience w/this.

Now, this department is being "taken over" by an "outside"
agency...budget problems have prompted the removal of a couple of depts.
and they are being adopted by other sources. This is supposedly a good
thing for the county, so I was given as a contact to aide in the
migration...basically just answering questions. I guess my boss has
setup some sort of support contract w/these folks.

Back to the actual question...I spoke to the new director of this
agency, yesterday, and he was surprised that they enter information from
Email directly. He asked if there wasn't a way to pick the data out of
the Email and put it into the DB. I told him that, what they should look
into was to have a form on their website, and this data could be put
into the DB, w/out human intervention. I did preface this by pointing
out that I did not know how to do this.

Is this possible? What does it take? What does it take considering the
DB is already existant and wasn't programmed for this? Also, they
currently use FrontPage for their site, which is hosted by an outside
provider. If it can be done, but not w/FrontPage, I just need to tell
them this. As it stands now, my involvement ends with a recommendation.
But, if it is doable, I am thinking of offering my services. It is just
that I am so busy right now, that I don't want to get in over my head
either.

Thank you

John W Clark
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com