D.3. The Properties Collection and Property Object

The Properties collection contains all of the property objects for a specific instance of an object. That's a confusing statement, but what it really means is that every object contains properties. All of those properties are stored in a Properties collection for that 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. You cannot delete either type of property.

D.3.1. Properties of the Property Object

All property objects have four properties of their own. Those properties are detailed in the following table.

PropertyData TypeDescription
NameStringString that identifies the property
TypeIntegerInteger that specifies the property data type
Value (default value)VariantA variant that contains the property setting
AttributesLongLong value that indicates characteristics of the property that are provider specific

There are no methods associated with the Property object.

Get Access 2003 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.