snyperj
asked on
Checking the connection string of a linked table
How can I get the full connection string of a linked odbc table?
I would like to be able to evaluate the string in code, specifically the name of the server is what I am looking for.
The name of the table is t_companies.
Thanks
I would like to be able to evaluate the string in code, specifically the name of the server is what I am looking for.
The name of the table is t_companies.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<evaluate the string in code>
I was assuming that you wanted this in VBA...
Also take a look at Jim Dettman's article on DLookup and the Domain functions for this sort of requirement:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html
I was assuming that you wanted this in VBA...
Also take a look at Jim Dettman's article on DLookup and the Domain functions for this sort of requirement:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html
;-)
select [name],connect
from msysobjects
where [name]="t_companies"