Linked table manager interface

G

Guest

I have a number of tables that are linked to tables in other databases.
However, they are linked to databases with such a long path of drives/folders
that I cannot see in the linked table manager exactly what they are linked
to.

The linked table manager is not sizable. Is there any way of seeing, in
code or otherwise, the specific path to where a specific table is linked?

Thanks.
 
G

Guest

currentdb.TableDefs("MyLinkedTableName").Connect

If the table is not a linked table, a zero length string will be returned
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables 1
Linked Table Manager works one at a time 4
Linked Table Manager 2
Access 2003 - Linked Tables? 2
linked tables dissapear 1
Why is Linked Table Manager list of tables empty? 1
Link two Jet tables in VBA 1
Can't Add a linked table to SQL Server 2005 with Access 2003 1

Top