Asp Problem Please help

Hi

I am having the following error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

while i try to update my table. I am using Access as backend. code i am using is
VB Code:
<html>
 
<head>
<title>New Page 2</title>
</head>
 
<body topmargin="0" leftmargin="0">
<!!--#include virtual="/adovbs.inc"-->
<%
Dim objConn
Dim counter ' TO COUNT RETURNED RECORDS
counter = 0
curDir = Server.MapPath("misc/db1.mdb")
set objconn = Server.CreateObject("ADODB.Connection")
set objrs = Server.CreateObject("ADODB.Recordset")
 
 
 
Response.write curDir
objconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & curDir
objrs.cursorLocation = 3
objrs.CursorType = 2
objrs.LockType = 4
ss="update guest set Name='gg' where sno=3"
 
 
objconn.execute ss
 
 
 
 
Response.write curDir
Response.write"<br>"
Response.write objconn
Response.write"<br>"
objConn.Close
 
%>
</body>
</html>
please help as i have been tring this for last two days is very much upset about this

This might help.

see here

hello u r using read only lock type..that is why u cannot update...so change the lock tpye and try it.....