Change Link Specs without Wizard?

[LarryP]

Only way I know to set up or change a link spec is via the Wizard; I can LOOK
at them by setting system objects (tables in this case) to visible, but can't
change them there. Anybody know how I can make changes directly in those
system tables? I know one has to know what one is doing, but for the most
part I'm talking about simple things like changing a fieldname.

 

[John Nurick]

An update query seems to work for me:

UPDATE MSysIMEXColumns
SET FieldName = "NewName"
WHERE (MSysIMEXColumns.FieldName="OldName")
AND (SpecID=3)
;

 

[LarryP]

Okay, I guess that'll do. Was hoping there is some magic word that will make
those tables "writeable" instead of just readable. Thanks again.