Changing link properties

[Andrea Williams]

We are working with an Access 2000 database and I need to know it it's
possible to change or update the link pointers on a linked table without
dropping and re-creating the linked table. We just switched websites and
the linked tables are now pointing to the wrong database server.

Thanks in advance,
Andrea

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" (or http://www.mvps.org/access/tables/tbl0010.htm if you're talking
about ODBC links)