Report for attached tables and paths

[MrTibbs]

Access 97
Which system fields are needed to report which 'back-end' databases tables are attached to a particular database front-end.
Ideally listing attached table and the path to it.
We can see them in 'linked table manager' but want a report our end users accounts can run

 

[ott]

If you unhide system objects you can get this information from the "MSysObjects" table.

The attached database path is listed in the field "Database" and the table names are listed in the "ForeignName" field.

 

[MrTibbs]

Works a treat. Thank you

Tony