link table problem

[\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?

 

[Albert D. Kallal]

The follwing should help:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

 

[Van T. Dinh]

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.

 

[\Allen Iverson\]

Is there a conversion application which will take the name of mdb and relink
all the tables?

 

[Van T. Dinh]

There is a RefreshLink method which you can use in a loop to refresh all
linked Tables in the TableDefs Collection.

See also The Access Web articles:

http://www.mvps.org/access/tables/tbl0009.htm

and

http://www.mvps.org/access/tables/tbl0010.htm