1) When updating a record in a recordset object the cursor becomes invalid after update. So the following doesn't work.
rs.open "Select * from...",cnn
rs!firstname = 'John'
rs.movenext 'move to next
rs.moveprevious 'move back again
rs!lastname = 'Smith'
'fails here because the cursor is invalid or something.
"Error -2147467259 Desc:Query-based update failed because the row to update could not be found."
In the mimer logdb it appears mimer deletes the record and inserts a new one to perform an update. ADO/Mimer doesn't seem to keep track of this.
This is a real problem using controls like MSFlexgrid/Datagrid in VB to alter data interactively because once a row is updated it becomes a big mess. Also, with a form bound to a recordset the data becomes invalid if the user changes a record.
Note: could only get ado to update if using a server side cursor.
It is a pity Mimer doesn't work well with ADO :( I suspect this is MS fault though.