I need help getting ASP and it's interaction with mdb's.

[PuddinPie]

Ok. I guess I'm just not getting it to the point that my brain is hurting.
I know HTML and and Access and am trying to base this backwards to that.
Here's what I would like to know how to do.

I want to create a site that accepts input from an EU in the form of text boxes and check boxes. Save the resaults as a veriable and then, upon clicking a submit button, dump the resaults into either an excel file or preferably an mdb.

I get the concept of useing an SQL injection to put the data into the Db's table but am not sure how to initiate it.

WHat I'm trying to say is it like an HTML file that the EU see's and fills out and it calls an ASP file which does the SQL call? because evertime I try to make and ASP file or copy a template I get nothing displayed in the browser window, trying to display it like an HTML file.

I'm not quite sure what to do. Can ASP be displayed in a browser for input purposes and how is the SQL initated.

Like I said I'm trying to invision it kind of like and HTML file even though I might be way off but that's all I seem to be able to see.

Can some one help please. Either with a basic tut or a demo program?

Thank you.

[pauledee]

Hey

The first thing to get right is the way in which you can test/view the ASP pages you create. Basically, opening them in a browser will not work locally... only on a local or remote web server that is running IIS or equivalent application hosting for ASP.
You'll also need to understand how to 'connect' to your database via a connection script or Data source name (DSN).

You can setup a local test server relatively easily but that's a separate topic.
Alternatively, you can use web space that you know will allow ASP code to run.

I think you probably need to do some reading on your topic before getting started. There are tons of code examples and tutorials out there. To get started type something like this into google...

"learn ASP access -.net"

Good luck!