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 adLockOptimisti c as follows, but still not working
objRS.Open "pressrelea se", objConn, adOpenDynamic, adLockOptimisti c
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]

Re: ADODB.Field error '800a0cb3'

Matthew Louden wrote:[color=blue]
> I tried to modify the field in my ASP page, and it yields the
> following error:
>
> I tried to use adLockOptimisti c as follows, but still not working
> objRS.Open "pressrelea se", objConn, adOpenDynamic, adLockOptimisti c
> 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[/color]

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