I'm using VB6 and access97,
I have an ADODC on one of my forms,
when I try to update with :
Adodc1.recordset.Update I get the following error:
Run time error
Row cannot be located for updating. Some values may have been changed since it was last read.
my form contains a comboBox with user names, the adodc presents each user's records.
(by clicking the combo and choosing a different name I'm refreshing the adodc with a new query)
The interesting thing is:
THE ERROR OCCURS ONLY when trying to update the first usre's records,
for other users it works fine.
This is a microsoft bug, I read this article:
RESOLUTION: To resolve this problem, remove the default value that is specified for the numeric field in the Access database table.)
and did what was suggested, but it still doesnt work.