links unreadable in Linked Table Manager

  • Thread starter Bill Reed via AccessMonster.com
  • 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
 
G

Graham R Seach

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
 
B

Bill Reed via AccessMonster.com

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
 
G

Graham R Seach

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
 

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

Top