[thelist] ASP: object read only?

[Casey Crookston]

Two questions.

First, I'm trying to update a record in my db (Access) and it keeps telling
me the object is read-only.  I thought that by specifying adLockOptimistic I
was making in not read only.  What else do I need to do? (See entire code
block below)

Second, I'm aware that this is the clumsy way to go about this process and I
would much rather just update the record from the SQL statement, but I'm not
sure of the VBScript syntax.  Any suggestions?  The query would look like
this: "UPDATE texts SET block = '"&block&"' WHERE text_id="&text_id" but
again it's the VBScript that I'm unsure of.

Many, many TIA's,

Casey

<!-- #INCLUDE FILE="../adovbs.inc" -->
<%
Dim Connect, rcrdSet, Query, text_id, text

text_id = request("text_id")

block = request("block")

Set Connect = Server.CreateObject("ADODB.Connection")

Connect.Open "boser_db"

Set rcrdSet = Server.CreateObject("ADODB.RecordSet")

Query = "Select block FROM texts WHERE text_id="&text_id

rcrdSet.Open Query, Connect, adOpenStatic, adLockOptimistic

rcrdSet("block") = block

rcrdSet.Update

Connect.Close

%>