BUG: Recordset Update Error Differs Between 16-Bit and 32-Bit (140309)
The information in this article applies to:
- Microsoft Visual Basic Standard Edition, 32-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
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
Modification Type: | Major | Last Reviewed: | 12/9/2003 |
---|
Keywords: | kbbug kbDatabase KB140309 |
---|
|