# ASP New user page not working

**URL:** <https://forum.kirupa.com/t/asp-new-user-page-not-working/53193>\
**Category:** programming\
**Created:** [June 1, 2004, 8:56am UTC](https://forum.kirupa.com/t/asp-new-user-page-not-working/53193 "2004-06-01T08:56:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![samotboy](https://avatars.discourse-cdn.com/v4/letter/s/ea666f/32.png) [@samotboy](https://forum.kirupa.com/u/samotboy)\
**Post date:** [June 1, 2004, 8:56am UTC](https://forum.kirupa.com/t/asp-new-user-page-not-working/53193/1 "2004-06-01T08:56:50Z")

</div>

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  
%\>