ASP New user page not working

1

Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/KOS/newuser.asp, line 23

<%
userform = Request.Form(“userinput”)
userpass= Request.Form(“passinput”)
set conn=Server.CreateObject(“ADODB.Connection”)
conn.Provider=“Microsoft.Jet.OLEDB.4.0”
conn.Open “C:\Inetpub\wwwroot\KOS\login.mdb”

set user = server.CreateObject (“ADODB.Recordset”)
user.Open “SELECT * FROM users”, conn
do while not user.EOF
if user(“username”)=userform then
Response.Write(“name taken”)
else
Response.Write(“Not Taken”)
end if
user.MoveNext
loop
Do Until user.EOF
if user.EOF then
user.AddNew “username”, userform
user.Update ’
user.Fields(“password”).Value = userpass
user.Update
Response.Write(“Inserted”)
end if
user.MoveNext
Loop
user.close
%>

2

your recordset needs a diff. cursor and location.
try-

set user = server.CreateObject (“ADODB.Recordset”)
user.cursorType = adLockBatchOptimistic
user.cursorLocation = adUseClient

'then do your open - make sure to include adodbc include file - if not, i believe aduseclient is 1 and adlockbatchoptimistic is 4…not sure about the last one numerically - may want to check it.