Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Checking the connection string of a linked table

Posted on 2011-09-22
4
Medium Priority
?
218 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:snyperj
  • 2
  • 2
4 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36580441
run this query


select [name],connect
from msysobjects
where [name]="t_companies"
0
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 36580466
It's in the MSysObjects table. Give this a try:

 DLookup("Connect","MSysObjects","[Name]='t_companies'")

Or using a variable:

 DLookup("Connect","MSysObjects","[Name]='" & strTableName & "'")



0
 
LVL 61

Expert Comment

by:mbizup
ID: 36580504
<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:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36580643
;-)
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question