R
rudy.knaap
Hi,
Is there a tool to visualize the cross-links between queries in an
Access database?
At work we use some databases with lots of queries and subqueries. E.g.
a report is based on a query A that gets its input from table B and
subquery C that joins subsubquery D and E etc. This makes it very
cumbersome to find out on what data a certain report is based or what
implications changing a certain query has for other queries.
I know Visio can visualize the relations between tables in a relational
database, but I can't get it to visualize the references between
queries and tables.
Regards,
Rudy
Is there a tool to visualize the cross-links between queries in an
Access database?
At work we use some databases with lots of queries and subqueries. E.g.
a report is based on a query A that gets its input from table B and
subquery C that joins subsubquery D and E etc. This makes it very
cumbersome to find out on what data a certain report is based or what
implications changing a certain query has for other queries.
I know Visio can visualize the relations between tables in a relational
database, but I can't get it to visualize the references between
queries and tables.
Regards,
Rudy