Reshape Name Property—Dynamic (ADO)
Specifies a name for the Recordset object.
Return Values
Returns a String value that is the name of the Recordset.
Remarks
Names persist for the duration of the connection or until the Recordset is closed.
The Reshape Name property is primarily intended for use with the re-shaping feature of the Microsoft Data Shaping Service for OLE DB service provider. Names must be unique in order to participate in re-shaping.
This property is read-only, but can be set indirectly when a Recordset is created. For example, if a clause of a SHAPE command creates a Recordset and gives it an alias name with the "AS" keyword, then the alias is assigned to the Reshape Name property. If no alias is declared, or the alias conflicts with an existing name, then the Reshape Name property is assigned a name generated by the Data Shaping Service.
Use the Reshape Name property when you want to refer to a Recordset in a SHAPE command, or when you don't know its name because it was generated by Data Shaping Service. In that case, you could generate a SHAPE command by concatenating the command around the string returned by the Reshape Name property.
Reshape Name is a dynamic property appended to the Recordset object's Properties collection when the CursorLocation property is set to adUseClient.