Get a list of linked tables from a database

[Access nubie]

looking for a way to export the list of table names, table types & if they are linked (e.g. tbl Sales Linked .dbf or tbl Staff linked to excel) from a database - this has to be done for about 300 databases.

in an individual db, I have a make table query off of the table MSysObjects to get the data. The Database field tells me where the source of the linked table resides & the ForeignName field gives me an idea of the format of the data source (e.g. dbf or excel). I could manually import that query into each db, run it to get the table names, then copy & paste.... i'm trying to eliminate some of the manual labor. Any ideas would be appreciated.

 

[Access nubie]

wow, ok, thank you. I'll need to get someone to help me with your above suggestion. this would be done as VB code within access? and then setup the looping to read all MDBs in the directory & puts the results into a table that will show the db names that have linked DBF files (or maybe the db names & names of tables linked to DBFs)?