Database structure

[boomer1974]

I have searched the forums and have not been able to find a solution to this one (if one exists) Has anyone been able to find a way to list all queries and which tables are used as data sources. Any help would be greatly appreciated.

Tx,
Boomer

 

[willir]

Boomer

Does the Documenter within Access give you what you want?

From the database window, select "Tool" -> "analyze" -> "Dcoumenter"

Richard

 

[boomer1974]

Well yes and no, it gives me the sql and the tables can be dirived from that but I would like to find a way to list out query names and those table names used for each query without having to sift through the sql.