# ASP New user page not working

**URL:** <https://forum.kirupa.com/t/asp-new-user-page-not-working/111878>\
**Category:** Uncategorized\
**Created:** [June 1, 2004, 8:56am UTC](https://forum.kirupa.com/t/asp-new-user-page-not-working/111878 "2004-06-01T08:56:50Z")\
**Posts on this page:** 2\
**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/111878/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  
%\>

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [June 16, 2004, 12:17pm UTC](https://forum.kirupa.com/t/asp-new-user-page-not-working/111878/2 "2004-06-16T12:17:33Z")

</div>

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.