In MS Access, is there a way in a Select Query to have it display the table names (and corresponding field names) from the whole MDB file? I know the documentor will pull this information, but it pulls the information into a text report... I need to more easily get the data into a table. About 12 years ago I remember doing this in a different version of SQL, but, unfortunately I haven't been able to find or recall the exact SQL statement that was used.

Thank you for your help!