UtterAccess.com
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    
 
   
allen_edgar
post Aug 10 2019, 05:13 AM
Post#1



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