Is it possible to query MS Access and create a list of columns for linked tables? I am able to list linked tables via
SELECT Name FROM MSysObjects WHERE Connect Is Not Null and Name like 'ID*' ORDER BY Name;
That provides the names of the linked tables, but what about the column names? I was hoping column names were stored in MSysDb, but trying to query that table causes an error.