mysysobjects

[seeker]

How do I update fields in mysysobjects table. Some of my table objects have
a dsn in the connection string. Others do not. I need to make the ones with
the dsn like the ones that do not have it. The reason is when I try to run
some reports it gives me an odbc error when those reports are based on the
table with the dsn string. Reports based on connection without dsn run
without error.

 

[seeker]

by wizard do you mean get external data or linked table manager? get
external data asks for a odbc connection

 

[seeker]

the table in question will not upsize. so I guess I am left with odbc issues
unless I can take the dsn part out of the string found in the connect column
in mysysobjects.

 

[John W. Vinson]

How do I update fields in mysysobjects table. Some of my table objects have
a dsn in the connection string. Others do not. I need to make the ones with
the dsn like the ones that do not have it. The reason is when I try to run
some reports it gives me an odbc error when those reports are based on the
table with the dsn string. Reports based on connection without dsn run
without error.

You don't. MSysObjects is (quite properly!!!) not updateable except by using
the builtin tools.

Delete the links and use the TransferDatabase method in code to create new
links to the correct link.