Link to MS SQL

[JMF]

I have many Access db which contain links to tables on a
Microsoft SQL server. Over the weekend we moved the SQL
tables to a different server with a different IP address.
I changed my ODBC connection to the new server and can
connect. I cannot open the linked tables in the Access
db's. The properties of the linked table in the
Description section contain the old IP information

ODBC;DSN=Campus;UID=report;APP=Microsoft®
Access;WSID=FORSBERG;DATABASE=campus;Network=DBMSSOCN;Addre
ss=xxx.xxx.xx.xx,1433;TABLE=dbo.course

I try putting in the new IP or DNS name but can't save
it. Is there some way I can update this information
without having to delete and relink every single table?

 

[Kevin @ 3NF]

Can you not re-link all the table at once via the linked table manager? I
ask because I have not tried it...

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



I have many Access db which contain links to tables on a
Microsoft SQL server. Over the weekend we moved the SQL
tables to a different server with a different IP address.
I changed my ODBC connection to the new server and can
connect. I cannot open the linked tables in the Access
db's. The properties of the linked table in the
Description section contain the old IP information

ODBC;DSN=Campus;UID=report;APP=Microsoft®
Access;WSID=FORSBERG;DATABASE=campus;Network=DBMSSOCN;Addre
ss=xxx.xxx.xx.xx,1433;TABLE=dbo.course

I try putting in the new IP or DNS name but can't save
it. Is there some way I can update this information
without having to delete and relink every single table?