Linked table properties

[Mike]

I want to change the connection string of my linked table properties. When
you try to modify the properties of a linked table, by going into 'Design
view' mode on the linked table, it tell you that not all of your modification
will be saved and it don't save the properties change. I just want to change
in 'Description' the table name of the connection string.

So, I will like to know, How can you change those propertises (The one I
am intrested to change is 'Description' where is the connection string) with
VBA code or any other way to modify those propertises.

 

[Douglas J. Steele]

What's shown in the Description field in the table's properties is actually
the table's Connect property. That's what you need to refer to in VBA.

 

[mnature]

Usually you cannot change anything in a linked table. You would have to open
the database that contains the actual table, in order to change something
about it. This is done purposefully, in order to prevent users from changing
tables. You may need to have the owner of the table make the changes that
you want.