Error 800a0cb3 when Updating

charlix · January 20th, 2004, 11:57 PM

I'm recieving the following error message when I try to update my Access 2000 database.

ADODB.Recordset error 800a0cb3: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

Yet when I try
If rs.Supports(adUpdate)

The response is that update is supported?

I can read the database but can not update it.

What gives?

planoie · January 21st, 2004, 10:11 AM

This error usually occurs because of missing write permissions on the directory, file or web/virtual directory in IIS. Check the permissions on those things.

Peter
------------------------------------------------------
Work smarter, not harder.

charlix · January 28th, 2004, 01:59 PM

I checked all the permissions. Virtual directory, Home directory, Database directory and ASP page all have read and write permissions. However, I still get the error message recordest can't be updated.

Charlie