Linked Table - What is the source table?

[gharabed]

If I have a linked table is there a way to get detail on the source that link is pointing to? In other words if that link (say I renamed it to "myTabLink&quot is using an ODBC DSN called "MyData" which points to a SQL Server database that contains two tables (say "A" and "A1&quot is there a way to tell from the link the DSN being used and the actual name of the source table to which the link is pointing?

 

[gharabed]

I found part of my answer. In the "Tools" menu, the "Linked Table Manager" shows the DSN and database. However, it does not show the actual source table name. Where might I find the actual source table name the link is pointing to?

 

[downwitchyobadself]

Use the .SourceTableName property of the tabledef object

Dim tdf as DAO.TableDef

debug.print tdf.SourceTableName

 

[cmmrfrds]

Click on the linked table and open in design mode. It says you can't modify, but ignore and open. Right click on the design frame and select properties. Under description should be all the information on the source for the table.

 

[DaveDG]

Try to open the linked table in design mode (Access will give a warning but open it anyway). RIGHT-click on the table to display a pop-up menu. Click Properties on the menu. The link should be displayed under Description. Hope this serves your purpose.

Dave