Article ID: 140309 - Last Review: December 9, 2003 - Revision: 2.0

BUG: Recordset Update Error Differs Between 16-Bit and 32-Bit

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

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.

Back to the top

16-Bit Error

Run-time error '3426':
The action was canceled by an associated object.

Back to the top

32-Bit Error

Run-time error '3020':
Update or CancelUpdate without AddNew or Edit.

Back to the top

CAUSE

The 16-bit error message is actually a Jet version 2.5 error message.

Back to the top

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

Back to the top

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.

Back to the top

MORE INFORMATION

Steps to Reproduce the Error in Visual Basic 4.0 16-Bit

Start 16-bit Visual Basic 4.0, or if it is already running, click New Project on the File menu.
Place a Data control on the Form1 form.
Set the Data control's DatabaseName property to Biblio.mdb.
Set the Data control's RecordSource property to Authors.
Add a TextBox control to the Form1 form. First set the TextBox control's DataSource property to Data1 and then set the DataField property to Authors.
Add a command button to the Form1 form.

Copy the following code sample to the Form1 code window:

       Private Sub Command1_Click()
          'To prevent the bug, uncomment the next line
          'Data1.RecordSet.Edit
          Data1.RecordSet.Update
       End Sub

Press the F5 key or click Start on the Run menu to start the program.
Enter some text in the text box.
Click the command button. The following error message appears in the Microsoft Visual Basic Dialog Box:
Run-time error '3426':
The action was canceled by an associated object.
Click the End button to close the dialog box and end the program.
Save the project. The project can be used to re-create the 32-bit error.

Back to the top

Steps to Reproduce the Error in Visual Basic 4.0 32-Bit

Start 32-bit Visual Basic 4.0 or if it is already running, click Open Project on the File menu.
Open the project that you just saved in step 12 above.
Press the F5 key or click Start on the Run menu to start the program.
Enter some text in the text box.
Click the command button. The following error message appears in the Microsoft Visual Basic dialog box:
Run-time error '3020':
Update or CancelUpdate without AddNew or Edit.
Click the end button to close the dialog box and end the program.

Back to the top