Problem with populating access db table from data submit from eb form

[Guest_imported]

I have created and Access table (database) and an HTML form with equivalent data fields (Using FrontPage - my pc is also configured as a server so I can test the function before placing the pages on the production server) . Using the Language= "VBSript" I wrote a basic SQL statement (including Conn.Open, Prod.Open, etc.) within an HTML page, to INSERT a new record in the access table and that is where my problems begin. I used the POST method and created an asp file to display the confirmation that the record was added which is where my problem occurs. The Response.Write works for records already in the db table but no records were added. Do I need to have a specific software installed on the server end to successfully run the SQL statement? Do I need to compile file that contains the query command (DML) with the the statement in a Visual Basic or JavaScript (.css) or another programming language?

 

[codestorm]

please give examples of the code codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>