Alex Rivera | Logout

How to refresh linked tables in an Access mdb when ODBC changes

Asked 2009-02-19T07:19:43.110
12

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.

Is there a way to relink these linked server tables without restarting Access?

EDIT: I would like to do this in code

ms-access odbc
Edit
Report

1 Answer

5

What version of Access are you using? In 2000, you can go to Tools>Database Utilities>Linked Table Manager to change your settings.

answered 2009-02-19T07:43:07.000

Your Answer