link table problem

  • Thread starter Thread starter \Allen Iverson\
  • Start date Start date
A

\Allen Iverson\

I have linked table in access mdb 97 through ODBC to SQL 2000 server. The
SQL 2000 server ip got changed and the server name remain the same. But the
lined table fails now because of the change. I need to re-link all the
tables. But there are too many. Is there a function which can refresh or
re-link all the tables automatically instead manually re-link tables?
 
If all the Tables are from the same DSN, then you can use the Menu Tools /
Database Utilities / Link Table Manager. Use the CommanButton to select All
Tables then OK. Access will re-link all Tables for you.

If you have to use a new DSN, then check the option "Always prompt for new
location" before OK.

If you want to use DSN-less ODBC-linked Tables, see Doulgas J. Steele's
article as posted by Albert.
 
Is there a conversion application which will take the name of mdb and relink
all the tables?
 
Back
Top