Microsoft KB Archive/190410

= PRB: Error Assigning Non-Opened Recordset to ADODC =

Article ID: 190410

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6
 * Microsoft Data Access Components 2.7

-



This article was previously published under Q190410



SYMPTOMS
When you attempt to set an ActiveX Data Objects (ADO) Data Control's Recordset object to a previously dimensioned ADO Recordset the following error is returned:

Run-time error '3704':

The operation requested by the application is not allowed if the object is closed.



CAUSE
This error occurs when the recordset has not been opened yet.



RESOLUTION
The user may either open the recordset prior to assigning it to the ADO Data Control (ADODC), or use the ADODC to create the recordset.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
 Open a Standard EXE Project in Visual Basic. From the Project\Component menu, select Microsoft ADO Data Control 6.0 (OLEDB). Place an ADODC on Form1.  Add the following code to the form: Private Sub Form_Load

Dim rs As New ADODB.Recordset ' Uncomment the below line to avoid error. ' rs.Open "Select * from authors", "DSN=Pubs", adOpenKeyset

Set Adodc1.Recordset = rs

End Sub 

RESULTS: The error occurs.

Keywords: kbdatabinding kbdatabase kbprb kbctrl KB190410

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.