Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Indicates the data source for a Recordset object.
Settings and Return Values
Sets a String value or Command object reference; returns only a String value that indicates the source of the Recordset.
Remarks
Use the Source property to specify a data source for a Recordset object using one of the following: a Command object variable, a SQL statement, a stored procedure, or a table name.
If you set the Source property to a Command object, the ActiveConnection property of the Recordset object will inherit the value of the ActiveConnection property for the specified Command object. However, reading the Source property does not return a Command object; instead, it returns the CommandText property of the Command object to which you set the Source property.
If the Source property is a SQL statement, a stored procedure, or a table name, you can optimize performance by passing the appropriate Options argument with the Open method call.
The Source property is read/write for closed Recordset objects and read-only for open Recordset objects.
Applies To
See Also
Source Property Example (VB)
Source Property (ADO Error)
Source Property (ADO Record)