Error in row

hi all,

I have an error when I was creating a web to add data to microsoft access database
the error is "Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver]Error in row
/Add.asp, line 54 "

detail of my database:
the name of the database is wardailer
the name of the table is table1
the primary key is ID

the code here :
_______________________________
<HTML><HEAD>

<%
Function ChkString(str)

str = replace(str, "<", "<", 1, -1, 1)
str = replace(str, ">", ">", 1, -1, 1)

ChkString = str
End Function

name = trim(ChkString(Request.form("name")))
email = trim(ChkString(Request.form("email")))
address = trim(ChkString(Request.form("address")))
City = trim(ChkString(Request.form("city")))
State = trim(ChkString(Request.form("state")))
Country = trim(ChkString(Request.form("country")))
Zipcode = trim(ChkString(Request.form("zip")))
Password = trim(ChkString(Request.form("password")))

ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("member.mdb")

set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open ConnString
set rscheck = my_conn.Execute ("Select email from member where email='" & email & "'")

if rscheck.eof then
been_here_before="No"
end if

RScheck.close
set rs = server.CreateObject("adodb.recordset")
if been_here_before="No" then
sql ="select * from member"

RS.open Sql,my_conn,1,3
RS.AddNew
RS("Name")=name
RS("email")=email
RS("address")=address
RS("city")=city
RS("state")=state
RS("country")=country
RS("zipcode")=zipcode
RS("password")= password
RS("memberdate")= now()

RS.update ' the error is here in this line
%>
</HEAD>
<body bgcolor="#99ccff">

<center>Your Account Has Been Processed!! 
Your User ID is : <%=email%>  , and your password is : <%=password%>

<a href="login2.asp">Go to Login Page </a>

</center>

<%
else
%>
<center>Your have signup already with this email 
Please signup with another your email address.

<a href="signup.asp">Sign up Again! </a></center>

<%
end if

rs.close
my_conn.Close
set my_conn = nothing
set rs = nothing
%></BODY></HTML>
_________________________________
help me plz
thanks alot

Try using SQL to insert data into the table. Employ the INSERT INTO statement.

Regards.

how to implement sql statements here ???

Here you go.

Code:

sql = "INSERT INTO member (Name, email, address, city, state, country, zipcode, password, memberdate)" & _ " VALUES (" & _ "'" & name & "', " & _ "'" & email & "', " & _ "'" & address & "', " & _ "'" & city & "', " & _ "'" & state & "', " & _ "'" & country & "', " & _ "'" & zipcode & "', " & _ "'" & password & "', " & _ "#" & now() & "#"

Regards,
Andrew Buntine.

hi my friend buntine

the problem was fixed

without using sql statement really the problem I found it in database itself

thanks buntine

Ok, good stuff ;)

hi al_3asel,

I have the same problem you have mentioned here.

would you tell me how you fixed that?

thx alot

Just make sure all values you assigned is valid (check for missing value in not null fields, numeric fields must have numeric values - empty is not a numeric, length of value must be less them field size for character values)