How to locate Access Linked Tables in SQL Server?

[jase2006]

I need to change the structure of some tables on SQL server and I only know the name of these tables in Access as Linked ODBC tables. But the naming of the Access tables are really messy and I can't locate the tables with the corresponding names. Is there a way I can track these tables down.

Thanks in advance

 

[JPMontreal]

Hi,
If you have access XP, I’m not sure with other version, just bring your mouse over the link table name and wait. An info window will pop up with the full information, including the source table or query name, on the SQL server, at the end.
Regards.


Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com

 

[genomon]

You can use Tools|Analyze|Documenter, or possibly Tools|Database Utilities|Linked Table Manager in Access to view the links back to SQL Server.

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[danvlas]

You could search MSysObjects table for ForeignName = 'dbo.YourTableName' and Connect Is Not Null

or something like that.

Connect column should contain something similar to 'DSN=ls;UID=sa;PWD=somefunnypassword;APP=Microsoft Office 2003;WSID=WorkstationName;DATABASE=Northwind'

There are many things you can do by using MSysObjects. Just open and study it for half an hour.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jase2006]

Thanks a lot guys! Didn't have the Access Analyser and Database features installed. So that's out of the question. But the MSysObjects table has all the info I need. Thanks danvlas!