Edit

Share via

Append method (ADOX Indexes)

  • Article

Applies to: Access 2013, Office 2013

Adds a new Index object to the Indexes collection.

Syntax

Indexes.AppendIndex [,Columns]

Parameters

Parameter Description
Index The Index object to append or the name of the index to create and append.
Columns Optional. A Variant value that specifies the name(s) of the column(s) to be indexed. The Columns parameter corresponds to the value(s) of the Name property of a Column object or objects.

Remarks

The Columns parameter can take either the name of a column or an array of column names.

An error will occur if the provider does not support creating indexes.