Finding Info On Linked Tables

[MDW]

Is there a way to find out information on linked tables? As in, what source the link is pointed to?

I'm primarily interested in finding out about linked Excel sheets. I've got a great deal of linked XL links, and I'd like to know what drive/path/file name the link points to.

I also have some links to SQL server, and if there is a way to find out the data source name and table also, but that isn't as important to me.

TIA.

 

[BerHav]

Hi,

if you right click on the table and select Linked Table Manager you will see all linked tables and source.

 

[MDW]

I don't know what version of Access you have, but in my install of A2000 I don't have that as a context-sensitive menu item.

HOWEVER, I was able to find the Linked Table manager off the "Tools" menu. That does what I need. Thanks!

 

[Roger Carlson]

Another way to find the path to a table WITHOUT the Linked Table Manager, is
to open the linked table in Design View. It will complain that there are
properties that you can't change. That's OK. Now go to Properties and at
the top, you will see the Connect string.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Is there a way to find out information on linked tables? As in, what source the link is pointed to?

I'm primarily interested in finding out about linked Excel sheets. I've

got a great deal of linked XL links, and I'd like to know what
drive/path/file name the link points to.

I also have some links to SQL server, and if there is a way to find out

the data source name and table also, but that isn't as important to me.

 

[BerHav]

I have Access 2002 ;-)

But I'm happy to help.

Regards,
Bernd