links unreadable in Linked Table Manager

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Reed - 04 May 2005 15:12 GMT

I would like to compile a table showing the path and db.name for all linked
tables in the db at the time it is opened. The linked table manager list
does not permit viewing the entire string and the dialog can't be stretched
to accommodate the string.

I experimented with a couple of things but had no success. Is there some
code out there that will append the paths and file names of the sources for
all linked tables in a db to a table?

Thanks,

Bill

Reply to this Message

Graham R Seach - 04 May 2005 15:22 GMT

Bill,

Create a query against the MSysObjects table.

SELECT [Name], [Connect], [Database], [Type]
FROM MSysObjects
WHERE [Type]=4 Or [Type]=6

If there's anything in the Connect field, its an ODBC-linked table. If
there's anything in the Database table, its a Jet-linked table.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

>I would like to compile a table showing the path and db.name for all linked
> tables in the db at the time it is opened. The linked table manager list
[quoted text clipped - 10 lines]
>
> Bill

Reply to this Message

Bill Reed - 04 May 2005 16:03 GMT

Graham,

EXCELLENT!!!

Thanks a million.

Bill

Reply to this Message

Bill Reed - 04 May 2005 16:08 GMT

Graham,

Is this table, MSysObjects, read-only? Not that I would want to do so, but
could I change a path or db.name in this query's results and thereby change
the source for the table? Would a typo in the path cause an unmitigated
disaster?

Thanks,

Bill

Reply to this Message

Graham R Seach - 05 May 2005 14:05 GMT

Bill,

Yes, it is read-only, but you can change the connection string through the
TableDef object:

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

> Graham,
>
[quoted text clipped - 7 lines]
>
> Bill

Reply to this Message