Link to MS SQL

[Jan]

I have several databases with tables linked to a MS SQL
database. We moved the SQL database to a different server
over the weekend and now my linked tables come up with an
ODBC error. I have reconfigured my ODBC but it appears
that the old IP is hardcoded into the linking information
for the table. Does anyone know how to fix this without
having to delete the tables from the Access db and relink
them?

 

[Douglas J. Steele]

What's wrong with deleting and recreating all of the linked tables? It
doesn't take that long. Remember, you aren't affecting any of the data:
linked tables are strictly pointers in your database.

See whether the code in http://www.mvps.org/access/tables/tbl0010.htm helps.