Need a way to get al the linked tables and con string to a table.

[sparkbyte]

I have several Access applications that use ODBC linked tables and need a way to get a list of all the linked tables and the connection strings associated with them into a SQL table.

Anyone have anything that I might use or a link to an example??

I trying to populate a table like this.

PK_ID,Application,ODBC_Driver,LinkedTableName,RemoteTableName,Server,Table,ConnString

Thanks

John Fuhrman

 

[PWise]

for starters

SELECT MSysObjects.Connect, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=4));

 

[PWise]

Sorry sb

SELECT MSysObjects.Connect, MSysObjects.Name,MSysObjects.ForeignName
FROM MSysObjects
WHERE (((MSysObjects.Type)=4));