ADODB Object

Attributes

 
Syntax
 
long = propertyobject.Attributes
 
Description
Returns a long value that is the sum of one or more FieldAttributeEnum values that define the characteristics of a Property object.
 
The Attributes property returns a long value that is the sum of one or more of the ParameterAttributesEnum constants that indicate the characteristics of a Property object.
 
Not all providers support this property.
 
PropertyAttributesEnum Constants 
 
Constant
Value
Description
adPropNotSupported
0
Not supported by provider
adPropRequired
1
Property must be specified before data source is initialized
adPropOptional
2
Property does not have to be specified before data source is initialized
adPropRead
512
User can read property
adPropWrite
1024
User can set property
See Also
Field.Attributes, Field.AppendChunk, Parameter.Attributes, Parameter.AppendChunk.
Example
 
If (objConnection.Properties(strName).Attributes = adPropNotSupported) Then
   Debug.Print "WARNING: Not supported by provider"
End If