Data Source Connections

[gwoman]

I inheritied an applicaiton that has many linked tables from many diffierent sources. I have used Linked Table Manager to see the properties but I am in need of finding out the connection strings or the schemas from which the tables are located. Is there something within Access that allows you to see this?
Thanks!
gwoman

 

[PHV]

You may have a look at the property sheet of the linked tables

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

Hold curser on the linktable icon for a second.. tool tip will show the location (Access 2002 or higher)
Or - (As PHV & RoyVidar[another thread] said)if you open the table in design view, ignore the warning, enter the properties, and it should be available in the "Description" property.



________________________________________
Zameer Abdulla
Visit Me
If you have never been hated by your child, you have never been a parent.

 

[gwoman]

Many thanks to both of you!
Have a good one!

gwoman

 

[GingerR]

Or view the MSysObjects table. It has them all listed.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244