How do I create a form using asp to query access database from user's
input via a form from a web page?

---

Clarification of Question by swykpisz-ga on 05 Aug 2003 06:39 PDT

Or is it better to have this done in php?

Check out numerous web sites for samples.  For example,
http://www.4guysfromrolla.com

If you can be a bit clearer about what you want to do. For example do
you want a form page where users can add input which affects the data
to be retrieved from the database

Jon

Yes,I need a form for users to input their ID and retrieve information
that is link to their ID through an access database. Is there an
example or a way to securely do this?

Yes, you can create a web based HTML form. This form will post a data
to ASP program. ASP program will be specified with database connection
parameters to your MS-ACCESS database.

You can use MS ADO-DB connection object to connect your MS ACCESS
database.
Once the database connection is established, you can query the
MS-ACCESS database with simple SQL statement. This SQL statement will
check the stored user details with user input details through web
based form.

Thats all.

Is there anyway someone can give me an example of a form or script I
could use to do this?

Hello,

 I will try to give you an example of script .. hope it's helpfull

 I made an example for you in ASP. It has 3 files:
 1. a.htm : the html file with the form
 2. test.asp : the asp that inserts users' data into database
 3. view.asp : the asp script that lists all users

 I made an archive with the files and you can download it from
http://www.advance3.com/gabi/asp.zip

 However if you are a beginner in ASP i suggest you take a phew hours
and read the documentation on ASP on this site
http://www.w3schools.com/asp/default.asp
 It was really helpfull for me.

 If you need more ASP examples you can find tons of ASP scripts on
this site:
 
http://www.pscode.com/vb/scripts/BrowseCategoryOrSearchResults.asp?optSort=Alphabetical&lngWId=4&B1=Quick+Search&blnWorldDropDownUsed=TRUE&txtMaxNumberOfEntriesPerPage=10&blnResetAllVariables=TRUE&txtCriteria=

 Hope it helps .. 
 Gabi