First step: Create the questionnaire in html.
Second step: Write the code in ASP to get information back from client.
Third Step: Create a table in Access to capture the feedback sent back from the client. This table consists of six columns which include the names( reason,response,rate,resolved and comments), and primary key. Fourth: Write the code in ASP to read and write information from questionnaire to the table.
Fifth: Task Complete.
Does this sound like the steps needed to complete this task.
Well, yes. Step two is kinda redundant because the data is sent to server upon submitting the form either way. But other than that those are the steps you need.
(1)Question: The database name for the statement below would that be Microsoft Access, the file name of the table or something else? Or is it the name you give when you set up the DSN?
Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("database_name.mdb")
(2)Question: How do you know which method to use or have to use between OLE DB or ODBC to connect to a database?
(3)Question: When I try to create the DSN, when I decide to Windows NT authentication or SQL server, either way I receive an error connection failed, any ideas why? I am using Windows XP professional.
(1)The "database_name" in the statement is the name of the actual Access database file (notice the extension). If you place your database file in a folder other that the one holding your asp files, folder names should be included here as well (eg. ("workdir/data/database_name.mdb") ).
(2) I'm not sure I even know that, but I guess it's database dependent.
(3) Don't think I understand the question. The connection string object used in the previously posted code is a non-DSN connection. There should no need to setup additional things to make it run.
I never use DSN connections my self, so I'm not that familiar with it.
If you want to use a DSN connection you can setup a user DSN on your computer through Control Panel -> Administrative Tools -> Data Sources (ODBC)
And then smth like (adoCon.Open "DSN=name_of_your_dsn_connection") should suffice as your connection object string.
Or you can always try Google (Google is our friend :cheesy: ) or maybe
http://www.iisanswers.com 
