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

[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]

Matthew Louden wrote:

> 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:
[url]http://www.aspfaq.com/show.asp?id=2062[/url]

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:
[url]http://tinyurl.com/qg4o[/url]
[url]http://tinyurl.com/qg3u[/url]
[url]http://tinyurl.com/qg47[/url]
[url]http://tinyurl.com/qg4j[/url]

HTH,
Bob Barrows

[Bob Barrows]

Matthew Louden wrote:

> 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:
[url]http://www.aspfaq.com/show.asp?id=2062[/url]

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:
[url]http://tinyurl.com/qg4o[/url]
[url]http://tinyurl.com/qg3u[/url]
[url]http://tinyurl.com/qg47[/url]
[url]http://tinyurl.com/qg4j[/url]

HTH,
Bob Barrows