Microsoft Access - Get The Details About a Linked Table's Data Source (Access 97/2000/2002)


When a database contains linked tables, you may at some point need to verify information about the source data, such as the location of the source file. There are a number of ways to find this information. The technique you probably use most often is to examine the contents in the Linked Table Manager. To access it, choose Tools | Database Utilities| Linked Table Manager from the menu bar (in Access 97, Tools | Add-ins | Linked Table Manager).


Unfortunately, the Linked Table manager leaves a lot to be desired. First, you can't resize it, and it often isn't wide enough to display the complete path to the source data. The dialog box in Access 2002 is an improvement over previous versions, but you still may find that it isn't wide enough to be consistently effective.


In addition, if a table is linked from an MDB file, the Linked Table manager doesn't display the original table's name. If you rename the linked table object, that's what appears in the Linked Table Manager.


Fortunately, there's an easy way to find out what a linked table points to, without resorting to a code-based solution or examining hidden system objects. To quickly find a linked table's source information, open the table in Design View, clicking Yes when Access informs you that some properties can't be modified. Then, right-click on the window's title bar and select Properties from the shortcut menu. When the Table Properties dialog box appears,you'll find the information you seek in the Description text box.

Go back