Query To find Table Connection String (1 Viewer)

[TallMan]

Hello -

I am using the following query to pull a list of all tables in my database that are connected using an ODBC connection:

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

I need to take this to the next step and be able to find out where the tables are linking to. Essentially, what their connection string is. (Server/Database)

Does anyone know if this is possible? This would be a HUGE help!!!

Thank you in advance for your time!

TallMan

 

[dylan_dog]

http://www.mrexcel.com/forum/microsoft-access/549769-access-2003-how-see-linked-table-path.html

Is this it?

 

[vbaInet]

MSysObjects has a Connect field so all you need to do is go back to your query and include that field there. But note, if you created a Pass Through query it won't show the connect string but linked tables are fine.

 

[TallMan]

All -

This works like a charm. Exactly what I needed.
Thank you very much for your time!

Tallman

 

[vbaInet]

You're welcome