>>>>One more thing to add to my initial message. I see this name ( AK_CompReference2) in Keys node and in the Indexes node. And attempting to delete it in either place fails. So my question is, should I modify it first? And if so, does it matter in which node do I modify it?
>>>
>>>Try to delete it through a Table Designer, Indexes.
>>
>>This does it. Thank you.
>>
>>Do you think I was able to delete it in the Table Designer, Indexes because this is where I created this index? (Honestly I don't remember doing it there but I don't remember what I had for breakfast either <g>).
>
>What was wrong in doing it through the code? BTW, did you script when you deleted it (just to see what code was generated)?
I don't know what you mean by "did you script when you deleted it". How do I script when deleting?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
