Edit

Share via

Index.Clustered property (DAO)

  • Article

Applies to: Access 2013, Office 2013

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.

Syntax

expression .Clustered

expression An expression that returns a Index object.

Remarks

The setting or return value is a Boolean data type that is True if the Index object represents a clustered index.

Some IISAM desktop database formats use clustered indexes. A clustered index consists of one or more nonkey fields that, taken together, arrange all records in a table in a predefined order. A clustered index provides efficient access to records in a table in which the index values may not be unique.

The Clustered property is read/write for a new Index object not yet appended to a collection and read-only for an existing Index object in an Indexes collection.

Note

  • Microsoft Access database engine databases ignore the Clustered property because the Microsoft Access database engine doesn't support clustered indexes.
  • For ODBC data sources, the Clustered property always returns False; it does not detect whether or not the ODBC data source has a clustered index.