Questions about Tables and Recordset and VBA

[Chatbox]

In my access project, I have a few Linked Tables (to a SQL server on the network).

Question 1: How do I get the connection string (via VBA coding) that each of the linked tables is using?

Question 2: (If Q1 is not possible) How do I create an ADODB.Recordset from a linked table when I don't have a connection string?

Thanks.

 

[Chatbox]

Anyone?

How come there's no reply? Is it because it's too easy/obvious and no one can bother...or no one know the answer?

 

[Pat Hartman]

Nobody uses Access Projects? In an .mdb you could open the MSysObjects table and look at the entry for the linked table or you could open the Linked Tables Manager. The problem with the Linked Tables Manager is that there is no way to increase th size of the form so if the path name is long, there is no way to see all of it.