links unreadable in Linked Table Manager

  • Thread starter Thread starter Bill Reed via AccessMonster.com
  • Start date Start date
B

Bill Reed via AccessMonster.com

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
 
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
 
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
 
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
 
Back
Top