Modify an indexed view (ADP)

Microsoft Office Access 2003

previous page next page
  1. In the Database window, click Queries Button image under Objects, click the indexed view you want to open, and then click Design on the database window toolbar.
  2. Modify the view in the Diagram and Grid panes of the Query Designer.

    Note   When you save the modified view, its indexes will be deleted and recreated.

ShowModify the index of an indexed view

  1. In the Database window, click Queries Button image under Objects, click the indexed view you want to open, and then click Design on the database window toolbar.
  2. Right-click the background of the Diagram pane and choose Manage Indexes from the shortcut menu.
  3. Revise the information for the index definition— index name, index columns and their order, index file group, and the other index settings. For more information about each dialog box option, click Help.
previous page start next page