You can do this but it takes some VBA.
Access defines a series of collections. Tabledefs, Querydefs, Modules, Documents, maybe a couple of others of lesser significance. Access Help on collections is available and not that hard.
In essence, you can write a VBA routine to scan the other collections to see what tables are called out in them.
If it is in Tabledefs, it does you no good to scan because after all, you are looking for a table reference. Well, in Tabledefs, you WILL find the table definition you were seeking.
In Querydefs, you will see queries that give you table names and field names. Or you can look at the .SQL of the querydef and parse out the contents of the FROM clause and the JOIN clauses. You can make your VBA code write out the table names and the names of the referencing query. When you see queries beginning with ~ as a query name, they were created by one of the form or report wizards when you used that wizard rather than doing a direct design.
In Documents, you will find closed copies of various forms and reports, which you have to open in design mode in order to examine. (In an otherwise inactive database, the Forms and Reports collections should be empty because you don't have any potential members of either of those collections open.) When you do open the document, you can see the recordsources for those forms and reports that are bound. You can also see class modules, which are normally stored as lines of code, line numbers restart with each module. See next topic for parsing...
In modules, you have the headache. By stepping through the Lines() collection in each class or general module, assuming it is an MDB and not an MDE, you can see the code as strings which can be parsed if you are patient enough. This is NOT for the faint of heart, but it is possible to look for certain things like OpenRecordset and the domain aggregate functions, each of which COULD have a table reference. You can also have an ExecuteSQL that names a table in the referenced SQL string, though that is a totally different can of worms if the string is built dynamically.
Other than that, I think you would have to look for a commercial product to do this kind of analysis for you.
