Access Database Design and Programming, Second Edition

Index Object

Collections

Property	Type	Version	Description
Fields	Fields	3.0/3.5	Collection of fields in the Index object
Properties	Properties	3.0/3.5	Collection of Property objects

Methods

Method	Parameters	Returns	Version	Description
CreateField	[Name], [Type], [Size]	Field	3.0/3.5	Creates a new Field object
CreateProperty	[Name], [Type], [Value], [DDL]	Property	3.0/3.5	Creates a new user-defined Property object

Properties

Property	Type	Version	Description
Clustered	Boolean	3.0/3.5	Indicates whether the index is clustered
DistinctCount	Long	3.0/3.5	Number of unique values in this Index object
Foreign	Boolean	3.0/3.5	Indicates whether an Index object represents a foreign key
IgnoreNulls	Boolean	3.0/3.5	Indicates whether Null values are stored in the index
Name	String	3.0/3.5	Name of this Index object
Primary	Boolean	3.0/3.5	Indicates whether this is a primary index
Required	Boolean	3.0/3.5	Indicates whether the index requires a non-Null value
Unique	Boolean	3.0/3.5	Indicates whether this is a unique index for a table