Name Property (ADO)

   Example   Applies To   

Indicates the name of an object.

Settings and Return Values

Sets or returns a String value. The value is read/write on a Command or Parameter object and read-only on a Property or Field object.

Remarks

Use the Name property to assign a name to or retrieve the name of a Command, Field, Parameter, or Property object.

For Parameter objects not yet appended to the Parameters collection, the Name property is read/write. For appended Parameter objects and all other objects, the Name property is read-only. Names do not have to be unique within a collection.

You can retrieve the Name property of an object by an ordinal reference, after which you can refer to the object directly by name. For example, if rstMain.Properties(20).Name yields Updatability, you can subsequently refer to this property as rstMain.Properties("Updatability").