Index members (DAO)

Applies to: Access 2013, Office 2013

Index objects specify the order of records accessed from database tables and whether or not duplicate records are accepted, providing efficient access to data. For external databases, Index objects describe the indexes established for external tables (Microsoft Access workspaces only).

Methods

Name	Description
CreateField	Creates a new Field object (Microsoft Access workspaces only).
CreateProperty	Creates a new user-defined Property object (Microsoft Access workspaces only).

Properties

Name	Description
Clustered	Sets or returns a value that indicates whether an Index object represents a clustered index for a table (Microsoft Access workspaces only). Read/write Boolean.
DistinctCount	Returns a value that indicates the number of unique values for the Index object that are included in the associated table (Microsoft Access workspaces only).
Fields	Returns a Fields collection that represents all stored Field objects for the specified object. Read/write.
Foreign	Returns a value that indicates whether an Index object represents a foreign key in a table (Microsoft Access workspaces only). .
IgnoreNulls	Sets or returns a value that indicates whether records that have Null values in their index fields have index entries (Microsoft Access workspaces only).
Name	Returns or sets the name of the specified object. Read/write String if the object has not been appended to a collection. Read-only String if the object has been appended to a collection.
Primary	Sets or returns a value that indicates whether an Index object represents a primary key index for a table (Microsoft Access workspaces only).
Properties	Returns the Properties collection of the specified object. Read-only.
Required	Sets or returns a value that indicates whether a Field object requires a non-Null value.
Unique	Sets or returns a value that indicates whether an Index object represents a unique (key) index for a table (Microsoft Access workspaces only).