title: How to refresh linked tables in an Access mdb when ODBC changes
body: <p>I can create an Access mdb and add a linked table to an Sql Server database via ODBC. If I change the Sql Server that the ODBC is connecting to with the ODBC control panel applet the mdb still connects to the original Sql Server until Access is restarted.</p>
  
  <p>Is there a way to relink these linked server tables without restarting Access?</p>
  
  <p>EDIT: I would like to do this in code</p>