AddNew/Update problem with ADO 
Author Message
 AddNew/Update problem with ADO

I want to edit an new record after an AddNew but I got an error with the
following code:

myRecordset!Date = "10.10.90"

' the added recordset is the current one without any requery
myRecordset!Date = "10.10.91"
myRecordset.Update                            <-ERROR

I get an error message that some values have changed since the last reading
of the underlying table
(the error message is in german so I cannot post it here)

Is it not possible to change a record twice after an Update-Method without
a requery ?
I used all possible cursor settings, this happens for Access-MDB's and my
SQLServer database.


// Juergen

Thu, 22 Mar 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. - addnew, edit, update, delete

2. AddNew and Update ADO methods

3. AddNew, Update, Delete in ADO???

4. ADO VB6 and Access ADDNEW and UPDATE

5. ADO Master/Detail Addnew Update???

6. Can't AddNew/Update with ADO Data Control

7. Cannot get autonumber after AddNew/Update with ADO (Visual Basic,Access97)

8. AddNew and Update through ADO

9. AddNew/Update autonumber problem

10. AddNew-Update problem

11. HELP: Addnew/Update problem

12. update/addnew problem..


Powered by phpBB® Forum Software