1
This is the error that i receive.
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/project/pages/addnew.asp, line 11
The code is;
<html>
<head><title>Displaying registered guest Table</title>
<%
Dim objconn,strconn,objrs
set objconn = server.createobject("ADODB.Connection")
strconn="provider=microsoft.jet.OLEDB.4.0; Data Source="& _
"c:\inetpub\wwwroot\project\pages\Register.mdb "
objconn.open strconn
set objrs= server.createobject("ADODB.Recordset")
objrs.open "register", objconn, 3,1
objrs.addnew
objrs("ADMNO")=request.form("admno")
objrs("NAME")=request.form("name")
objrs("DATE FO BIRTH")=request.form("dob")
objrs("ADDRESS")=request.form("add")
objrs("FEES")=request.form("fees")
objrs.update
objrs.close
%>
</head>
<body>
<table border=1>
<%
objrs.open "register",objconn
while not objrs.eof %>
<tr>
<td> <%=objrs("ADMNO")%></td>
<td> <%=objrs("NAME")%></td>
<td> <%=objrs("DATE FO BIRTH")%></td>
<td> <%=objrs("ADDRESS")%></td>
<td> <%=objrs("FEES")%></td>
</tr>
<%
objrs.movenext
wend
objrs.close
objconn.close
set objrs=nothing
set objconn=nothing
%>
</table>
</body>
</html>
NOTE:Iam A Begginner in asp please help me.
