Update an index (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

Your index is automatically saved in the database when you save your table or database diagram. The index is available for modification as soon as you create it.

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the database window toolbar.
2. In your database diagram, right-click the table and choose Properties from the shortcut menu.
3. Choose the Indexes/Keys tab.
4. To update the definition, select the option you want to update and change its value or setting. For more information on each property, click Help.

Your changes are saved to the database when you save the database diagram.

Note that you can also manage indexes on some views.