Primary Property

See AlsovbproPrimarySee                 ExamplevbproPrimaryEx>Low (Professional Edition Only)

Applies To

Index object1WDWMJT.


Determines if an Index can be used to uniquely identify each record in a table.  Not available at design time; read-only when the Index is a member of a collection.  Read/write only in the Professional Edition with a new object not yet appended to a collection.


index.Primary [ = True | False }]


Many relational database management system (DBMS) products require at least one unique index, called a "primary key," on every table.  Microsoft Access allows tables without a primary key, but if the table grows large, finding records can be slow and you cannot use queries that create joins between it and any other table.

Only one index per table can be a Primary index.

In the Professional Edition, when you create a new table in your database, it's a good idea to create an index on one or more fields that uniquely identifies each record, then set the Primary property of the Index object to True.

Data Type

IntegerDOKXHY (Boolean)