Dear Memebers

I am new to ASP I have to build Admin Page using ASP which must be capable of
Add,Delete,Update a Record

My Question are

1. In order to Add a record How can I get Values from field i.e. I have three
Text Boxes named text1,text2,text3 respectively two buttons 1 for Submit and
other for Reset

Form Actio is "Get"

I am using following Qury

I am just writing ASP code It must be noted that all the fields in Table are
Text Type

<%
Response.Expires = -1000
Dim oConn
Dim oRS
Dim sSQL
Dim sColor
Dim GetVal
If Category<>"" Then
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("abc.mdb"))
sSQL= "INSERT INTO Info VALUES ('" & text1 & "','" & text2 & "','" & text3 &
"')"
Set oRS = oConn.Execute(sSQL)
oConn.Close
Set oRS = Nothing
Set oConn = Nothing
end if
%>
i have also tryied

sSQL= "INSERT INTO info VALUES ('p','p','d')
but I am getting HTTP error what is wrong with this Query ?

when I use Query to retrive Data it works fine but whenever I try to perform
Add,Delete,Update operations I get HTTP error

Plz help me to solve this Problem

Thanks in Advance

Munawer






---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.

[Non-text portions of this message have been removed]