Can you designate a field as a KEY . . .

with any of the tools in VB 6.0? I've played with the Data View & VisData, but cannot seem to designate a field as KEY. How? Or do you have to do this with Access app?

Also, how do you get Database Diagrams to show up using Data View? I get Table & Views, but not Database Diagrams. (?)

Would sure appreciate any comments or s****.

Thanks,
John

you need to use the tabledef object and reference an existing index or create a new one - then

Set AuIdx = MyTd.CreateIndex("AuthorID")
AuIdx.Primary = True
AuIdx.Unique = True

there are examples in Books On Line in help

Thanks for your excellent response. In developing DB apps, do you think the Enterprise edition is necessary or worth the extra $?

Thanks in advance for your opinion.
John