ADODB.Field error '800a0cb3'

[Matthew Louden]

I tried to modify the field in my ASP page, and it yields the following
error:

I tried to use adLockOptimistic as follows, but still not working
objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic
ADODB.Field error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.

any ideas? thanks

 

[Bob Barrows]

I tried to modify the field in my ASP page, and it yields the
following error:

I tried to use adLockOptimistic as follows, but still not working
objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic
ADODB.Field error '800a0cb3'

Current Recordset does not support updating. This may be a limitation
of the provider, or of the selected locktype.

any ideas? thanks

We'll need a little more information than that:

Database type and version

The code you used to generate the error.

If it's an Access database, this may be relevant:
http://www.aspfaq.com/show.asp?id=2062

But the error message is puzzling.

You should not be using a recordset to modify your data. You should be using
SQL DML statements (UPDATE, INSERT and DELETE), preferably encapsulated in
stored procedures or saved parameter queries. see these links to see how
easy it is:
http://tinyurl.com/qg4o
http://tinyurl.com/qg3u
http://tinyurl.com/qg47
http://tinyurl.com/qg4j

HTH,
Bob Barrows