# ASP and Access

**URL:** <https://forum.kirupa.com/t/asp-and-access/159067>\
**Category:** programming\
**Created:** [August 14, 2005, 1:28pm UTC](https://forum.kirupa.com/t/asp-and-access/159067 "2005-08-14T13:28:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![adityadubey](https://avatars.discourse-cdn.com/v4/letter/a/f17d59/32.png) [@adityadubey](https://forum.kirupa.com/u/adityadubey)\
**Post date:** [August 14, 2005, 1:28pm UTC](https://forum.kirupa.com/t/asp-and-access/159067/1 "2005-08-14T13:28:10Z")

</div>

hi!  
this code doesn’t work. Is there an error somewhere??

\<% dim conn  
set conn = Server.CreateObject(“ADODB.connection”)  
conn.open “icopdb”  
set rs = conn.execute(“INSERT INTO registration (Name,Age,Gender,Nationality,Designation,Field,Institute,Address,Email,Telephone,Amount,Mode,Date) VALUES (’” &request.Form(“rname”)& “’,” &request.Form(“rage”)& “,’” &request.Form(“rgender”)& “’,’” &request.Form(“rnationality”)& “’,’” &request.Form(“rdesignation”)& “’,’” &request.Form(“rfield”)& “’,’” &request.Form(“rinstitute”)& “’,’” &request.Form(“raddress”)& “’,’” &request.Form(“remail”)& “’,’” &request.Form(“rtelephone”)& “’,” &request.Form(“ramount”)& “,’” &request.Form(“rmode”)& “’,” &request.Form(“rdate”)& “)”)

response.redirect “reg.htm”  
%\>

Regards  
Aditya