Deleting a Record From an ADO Recordset 1

[jerjim]

When I try to delete a record from an ADO recordset, I get the error
"Insufficient key column information for updating or refreshing"

Prior to the delete method,
I have already filtered the recordset so that it contains only one record,
the record I want to delete.

The lines of code are:
With rst
.filter = "filter expression"
.delete
.update
.requery
end with

The error occurs when I call the .delete method.

 

[MatsHulten]

First check if the recordset supports delete or not (

rs.supports(adDelete)

) and if it does, check the errors collection for more information.

The code looks fine to me, except I would be more implicit about the delete method (using adAffectGroup), but it should work nevertheless.

To me this looks like a problem when you connect to the database, or in the way that you retrieve the data.

Good Luck
-Mats Hulten