Index Members (DAO)
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 |
|---|---|
Creates a new Field object (Microsoft Access workspaces only). |
|
Creates a new user-defined Property object (Microsoft Access workspaces only). |
Properties
Name |
Description |
|---|---|
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. |
|
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). |
|
Returns a Fields collection that represents all stored Field objects for the specified object. Read/write. |
|
Returns a value that indicates whether an Index object represents a foreign key in a table (Microsoft Access workspaces only). . |
|
Sets or returns a value that indicates whether records that have Null values in their index fields have index entries (Microsoft Access workspaces only). |
|
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. |
|
Sets or returns a value that indicates whether an Index object represents a primary key index for a table (Microsoft Access workspaces only). |
|
Returns the Properties collection of the specified object. Read-only. |
|
Sets or returns a value that indicates whether a Field object requires a non-Null value. |
|
Sets or returns a value that indicates whether an Index object represents a unique (key) index for a table (Microsoft Access workspaces only). |