Indexed add to tables

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I have indexes show up in tables that I don't want to maintain and I'm not
sure how they are getting there.

Can indexed be added to tables - not by directly in Table design or in vba
code?

Are they added when queries are made?

Any other way other than intentionally?

Thanks.
 
There are specific characters in field names that might autonmatically
create indexes. For instance, by default field names containing "ID",
"Code", "Key", and "Num" will automatically create indexes. Select
Tools->Options->Tables/Queries->AutoIndex...
 
Thanks.

I've already made the tables and set the indexes.

Can indexes be made on the fly without code?
 
Back
Top