ADO ERROR: Row cannot be located for updating. Some values may have been changed sinc

[Tengkorak]

Hello all,

i have problem when i update my record from database (i used Ms Access Database)
this the message error:
Row cannot be located for updating. Some values may have been changed since it was last read.

can anybody give the solution for this ?

[VB-Nerd]

can you put a little code snippet up of what you are doing on the save and how you are connecting the the rs.

does this same method work in other parts of the app?

is this the only location of where things are changing?

[Petergotchi]

Without showing any code, it's gonna be difficult.

Maybe this happens because you are updating (or batchupdating) many records at the same time. Try using objRecordset.Requery to update all the records in the recordset by re-executing the query.

Or maybe you have mistakes in your primary keyfield. Is it set to auto-enumerate? Or do you compose that field yourself?

They're just lucky guesses, but maybe they're worth something. If not, be a little bit more descriptive. ;-)

Good luck!

[Campion]

Try changing the pointer (indexer? Help me out here. I don't have VB in front of me) to adUseClient. This is how I've solved this pesky error before.

edit:

Okay, here is the item I'm trying to say:

objRS.CursorLocation = adUseClient