RE: Database error: Row handle referred to a deleted row or a row marked for deletion

SSC Veteran

Points: 293

January 20, 2017 at 3:52 pm

#1924165

Sue_H - Friday, January 20, 2017 3:32 PM
It's not a SQL Server issue or error, doesn't have anything to do with SQL Server. It's an ADO recordset issue/error. You don't have the current recordset at the time you movenext. It's been too long that I have no idea how to address that. Some way to requery or use a different recordset type is all I can think of.
No idea what is a good ADO forum either but that would be where you would want to post this.
Sue

Hi Sue, I had similar thoughts this was a ADO recordset issue but it doesn't occur with Access and didn't occur for this client with this same piece of code until recently so I didn't want to rewrite the code if the problem exists in some ADO driver that only allows a limited number of record sets to be returned. What's strange is that this code doesn't fail with 1 in the record set, just 2 or more so the movenext should fail with 1 too. I'm not that familiar with this forum so if you know of a more focused post area let me know.