Indexed add to tables

[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.

 

[Duane Hookom]

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...

 

[SAC]

Thanks.

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

Can indexes be made on the fly without code?

 

[Duane Hookom]

Indexes are also added when you set relationships.

 

[SAC]

Thanks, again.

Indexes are also added when you set relationships.