run-time error -2147217885 with RecordCount
Posted on 2003-03-05
I am retrieving the current record number and the total records in the database with .AbsolutePosition and .RecordCount in a MoveComplete() event in an ADO recordset. During testing, a problem arose when I tried to add a duplicate record to the database. When I acknowledge the error and then Cancel the update, I get -2147217885 error, something about deleting a record. I think the problem is that the MoveComplete event adds to the record count before the update is actually completed. I tried placing it in the Reposition event, but that doesn't work at all. Can anyone help me?