0

I'm referencing 1 single table as output from multiple query updates. Is there a way to force this table to always have the Indexed value remaining TRUE for specified fields? The issue is because the table's fields get modified after execution of each type of query and I currently have to click and change the Indexed fields to "Yes" before executing the next query.

This Indexed property in Microsoft Access helped resolve my issue with processing power for the thread below: Exclude Certain Records with Certain Values SQL Select

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
stitch70
  • 143
  • 1
  • 3
  • 15

1 Answers1

0

This does it: Change Index Settings Access VBA

Change it to below if duplicate values are required (removing the UNIQUE keyword): CREATE INDEX Index1 ON Cars (ID)

Community
  • 1
  • 1
stitch70
  • 143
  • 1
  • 3
  • 15