Article ID: 140309
Article Last Modified on 12/9/2003
APPLIES TO
- Microsoft Visual Basic 4.0 Standard Edition
- Microsoft Visual Basic 4.0 Professional Edition
- Microsoft Visual Basic 4.0 Professional Edition
- Microsoft Visual Basic 4.0 16-bit Enterprise Edition
- Microsoft Visual Basic 4.0 32-Bit Enterprise Edition
This article was previously published under Q140309
SYMPTOMS
When running Update method on a recordset, the error message displayed for
16-bit Visual Basic and 32-bit Visual Basic are completely different.
However, the cause of the error is the same. You didn't use the AddNew or
Edit method before trying to save changes to a record.
16-Bit Error
Run-time error '3426':
The action was canceled by an associated object.
32-Bit Error
Run-time error '3020':
Update or CancelUpdate without AddNew or Edit.
CAUSE
The 16-bit error message is actually a Jet version 2.5 error message.
WORKAROUND
To workaround this bug, use the Edit method before the Update method, prior
to saving the changes to a recordset, as shown below:
Data1.RecordSet.Edit
Data1.RecordSet.Update
STATUS
Microsoft has confirmed this to be a bug in the 16-bit version of Visual
Basic 4.0. We are researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.
REFERENCES
For additional information on Visual Basic 4.0 error messages, please see
the following article in the Microsoft Knowledge Base:
136250 LONG: List of Trappable Errors for Visual Basic 4.0
Additional query words: 4.00 vb4win vb4all buglist4.00
Keywords: kbbug kbdatabase KB140309