mysysobjects

S

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.
 
S

seeker

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

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.
 
J

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.
Click to expand...

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.
 
Top