X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Duplicate Index Created By Relationship, Access 2016    
post Aug 10 2019, 05:13 AM

Posts: 23
Joined: 7-May 17

When I loop thru a Tabledef.Indexes collection, I note that there are often more indexes than are listed in the table design indexes dialog. This is because I specifically included indexes when I built the table not realizing that Access will create another identical index if I later create a relation to another table that includes the same field name.

My question is: Should I remove the original index I created in table design view so that Access is not updating two identical indexes every time a new record is added? I guess this is a performance issue. Am I missing something?
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    23rd January 2020 - 09:15 PM