I have a program that browses an Access 2000 table with an ADO connection in VB 6. I want to add functionality so the user can click on a row to pop open an editing form, and then I want to update the table with their changes after I validate them.

I have the editing form opening just fine.

Can you tell me what I need to do to update the fields in the database table, without screwing other rows up? Failsafe, time-tested method preferred.

Even more helpful, can you suggest a book or other hopefully concise reference I can use to learn all about VB ADO database programming?

Thanks - Tom