PDA

Click to See Complete Forum and Search --> : Chaning a recordset when using ADO


snhuskey
Sep 16th, 2000, 05:58 PM
I have a simple program that goes through recordsets in a MDB. I have not created the database object using code. I have created it using only the ADO control properties.
All the fields in the database are presented in seperate text boxes. The problem I am haveing is that when I browse the database and then change the current record being displayed I get an error # -2147217864 I looked at the error number in help but it doesnt really tell me how i can work around this. It has something to do with the record being changed since it was last read. How can I change a record with out getting this error? Remember, I am using the ADO control properties if that helps.

Please help.

Thanks.

Clunietp
Sep 17th, 2000, 11:06 AM
What is the exact error message that you are getting?

snhuskey
Sep 17th, 2000, 12:05 PM
Hi thanks for the reply.

The exact error message is:

Run-Time error '-2147217864

The specified row could not be located for updating: Some values may have been changed since it was last read.