Manage Linked Tables in Microsoft Access


Many departments inherit or share Access databases, and may need to update or troubleshoot connection errors with linked tables. Below are some basic troubleshooting tips. 


For the most updated directions on using the Linked Table Manager in Access, please visit Microsoft's Website here: Manage Linked Tables

Finding ODBC Names and Table Sources

  1. Open the database in Access. Click on the External Data tab and click on Linked Table Manager. 

  2. In the new window, you will see a list of all linked tables in the database. In parentheses will be the information you need to create a new ODBC connection on your computer. 
  3. The DSN is the name of the ODBC Connection.
  4. The DATABASE is the default database you are connecting to.


Article ID: 78487
Fri 5/17/19 11:58 AM
Mon 11/11/19 2:39 PM

Related Articles (1)

This connection is needed in order to use Jenzabar-linked tables for Access reporting.