Change Link Specs without Wizard?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
An update query seems to work for me:

UPDATE MSysIMEXColumns
SET FieldName = "NewName"
WHERE (MSysIMEXColumns.FieldName="OldName")
AND (SpecID=3)
;
 
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.
 
Back
Top