E.3. Properties Collection and Property Object

The Properties collection contains all of the Property objects for a specific instance of any given object. The previous statement may be somewhat confusing, but what it really means is that every object contains properties. All of those properties are stored in a Properties collection for that particular object. The Properties collection for the Error object contains the Description, Number, Source, SQLState, and NativeError properties. There are two types of properties: dynamic and built-in. Neither type of property can be deleted.

E.3.1. Properties of the Property Object

Every Property object has four properties of its own, which are detailed in the following table.

PropertyDataTypeDescription
AttributesLongLong value that indicates characteristics of the property that are provider specific.
NameStringString that identifies the property.
TypeIntegerInteger that specifies the property data type.
ValueVariantThe default property value. A variant that contains the property setting.

No methods are associated with the Property object.

Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.