Update Error after record is written in the database

[vias]

I'm writing into an Access database.

I'm getting this error although the record has been
successfully written in the db.

Microsoft OLE DB Provider for ODBC Drivers error '80040e2f'

[Microsoft][ODBC Microsoft Access Driver]Error in row

/signup2.asp, line 187


Here is the code :
---------------------------------------------
set conn = server.CreateObject ("adodb.connection&quot
conn.Open Application("strConn&quot
set rs = server.CreateObject("adodb.recordset&quot
rs.Open "select * from Users where 1=2",conn,1,3
rs.AddNew

rs("Uname&quot = uname
rs("Pwd&quot = Pwd
rs("FName&quot = FName
rs("LName&quot = LName
rs("UEmail&quot = UEmail
rs("Sex&quot = sex
rs("BDate&quot = BDate
rs("Pwd&quot = Pwd
rs("City&quot = city
rs("Country&quot = country
rs("Infofrom&quot = infofrom
rs("Status&quot = "N"
rs.Update <================ error on this line (187)

session(&quot;UName&quot = uname
rs.Close
-------------------------------------------
Can i have your feed-back please.

Thanks

 

[Genimuse]

A couple of things I see, though I don't know that they're causing the problem: You're setting the Pwd twice (but I wouldn't think this would cause an error), and your Select statement is odd to me (where 1=2)... is &quot;1&quot; a field name?