database read-only error

<i><b>Originally posted by : gujju</b></i><br />this is the set up for database<br /><br /><br />Dim objConn<br />Dim rsguest<br />Dim strSQLL<br /><br />Set objConn = server.CreateObject "ADODB.Connection")<br />Set rsguest = Server.CreateObject("ADODB.Recordset")<br />objConn.Open "DBQ=" & Server.Mappath("xxxx.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"<br />strSQLL = "SELECT * FROM guest"<br />rsguest.Open strSQLL, objConn , 1, 2, 1<br /><br /><br />rsguest.addnew 'line 33<br />rsguest("name") = "vname" 'line 34<br />rsguest("email") = "vemail" 'line 35<br />rsguest.update 'line 36 <br /><br /><br />this gives the error<br /><br />"Database or object is read-only. <br />/svguest.asp, line 36" <br /><br />

<i><b>Originally posted by : j</b></i><br />looks like your recordset cursors are wrong. <br />http://www.microsoft.com/data/ado/adords15/docs/adomth03_1.htm<br />there is a link with the cursor types with descriptions. <br /><br />------------<br />gujju at 5/26/2000 6:25:13 PM<br /><br />this is the set up for database<br /><br /><br />Dim objConn<br />Dim rsguest<br />Dim strSQLL<br /><br />Set objConn = server.CreateObject "ADODB.Connection")<br />Set rsguest = Server.CreateObject("ADODB.Recordset")<br />objConn.Open "DBQ=" & Server.Mappath("xxxx.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"<br />strSQLL = "SELECT * FROM guest"<br />rsguest.Open strSQLL, objConn , 1, 2, 1<br /><br /><br />rsguest.addnew 'line 33<br />rsguest("name") = "vname" 'line 34<br />rsguest("email") = "vemail" 'line 35<br />rsguest.update 'line 36 <br /><br /><br />this gives the error<br /><br />"Database or object is read-only. <br />/svguest.asp, line 36" <br /><br />