ACC2000: Cannot Set Form Recordset to Disconnected Recordset (230737)
The information in this article applies to:
This article was previously published under Q230737 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
When you try to assign an ActiveX Data Objects (ADO) Recordset object to a form, you may receive the following error message:
The object you entered is not a valid Recordset property.
CAUSE
You assigned a disconnected ADO Recordset object to the Recordset property of the form.
RESOLUTION
Set the ActiveConnection property of the ADO recordset to a valid ADO Connection object before assigning it to the form.
REFERENCES
For additional information about using disconnected recordsets with ADO, please see the following articles in the Microsoft Knowledge Base:
190717 Disconnected Recordsets with ADO or RDS
184397 Getting ADO Disconnected Recordsets in VBA/C++/Java
For more information about using the form Recordset property, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type Form Recordset Property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 12/12/2002 |
---|
Keywords: | AccessCS KbClientServer kbdta kberrmsg kbprb KB230737 |
---|
|