Rename an index (ADP)

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

New indexes are automatically given system-defined names based on the database table name. If you create multiple indexes on a table, the index names are appended with "_1", "_2", and so on. You can rename an index as long as index names are unique within the table.

Note   When you create a primary key or unique constraint for a table, an index with the same name as the constraint is automatically created for the table. Because index names must be unique for a table, you cannot create or rename an index to have the same name as the primary key or unique constraint for the table.

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, select the table whose index you want to rename, right-click the table, and choose Properties from the shortcut menu.
3. Choose the Indexes/Keys tab.
4. Select the index from the Column name list.
5. Type a new name in the Index name box. Make sure that it does not duplicate a name in the Column name list.

The index is renamed in your database diagram when you exit the Index name box. It is renamed in the database when you save the database diagram.