Collecting data over web

S

Sara Paullin Casto

I have created an access database that I would like others to be able to add
data to. In some cases, I don't want to show the data over the web, just add
to it with a form on a web site. Ideally, I want users to complete a form
online and submit it, then a notification email would be sent to me to let me
review the data before the database was amended. I could edit the info if I
wanted and then confirm the change to the database.

Can I do this with data access pages? I am using Dreamweaver MX to design
the web site and I can create forms with it, but I can't figure out how to
get the data to go anywhere. I have heard the acronyms ASP and CGI, but I
don't know enough to know what that is, not to mention where to begin. And
the techies where I work aren't familiar with it either. I thought that data
access pages might be a way to get around this problem.

Advice for me?
Thanks!
 
N

Norman Yuan

Your question is about how to make a web application and has little to do
with database itself. Sure, what you want to is doable. Actually, most web
applications involve database nowadays.

Since you ask this in Access NG, I'd like you to know that Access is not a
good choice for public web application (but you can use it, for sure). Also,
Access's Data Page (since Access2K) is also not very good choice for public
web app. It is more suitable for intranet environment.

The web app you want can be done with any current web technology, CGI, ASP,
ASP.NET, PHP, Perl, Java...Depending on the comlexity of your requirement,
it can be done in several days to months with cost as low as a few hundreds
dollars to tens of thousands.
 
Top