Specify a fill factor for an index (ADP)

Microsoft Office Access 2003

  1. In the Database window, click Database Diagrams Button image 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 containing the index for which you want to specify a fill factor, and choose Properties from the shortcut menu.
  3. Choose the Indexes/Keys tab.
  4. Select the index from the Column name list.
  5. In the Fill factor box, type a percentage from 0 to 100.

ShowSpecify a fill factor for an index on a view (Microsoft SQL Server 2000 only)

  1. In the Database window, click Queries Button image under Objects, click the view you want to open, and then click Design on the database window toolbar.
  2. Right-click in the Query Designer, and choose Manage Indexes from the shortcut menu.
  3. Select the index from the Column name list.
  4. In the Fill factor box, type a percentage from 0 to 100.

For more information about fill factors and their uses, see the SQL Server documentation.