4TOPS Query Tree Editor is an add-in for MS Access for query development and analysis. The Query Tree dialog displays the dependency tree of a selected query (Uses / Used By). The buttons on the dialogs support a natural way of working with queries, smoothly switching from the tree overview to query editing to saving different versions or running them to evaluate the results. Double-click on a query opens the query datasheet. Press the Edit button to make required changes using the Query Editor. The Print button writes the tree to the Debug Window. Use it to compare query dependency trees or to paste it into your documentation. Double-click on multiple queries to compare results. This will help you diagnose in case queries don't return the results you expected.
There are templates for the most usual sql. New is Verify and Find. Verify in one click that all queries still work after changes and Find all queries/tables that use a certain Field.
Supports Access 2000-2007.
sql - query - tree - dependencies - depends on - uses - used by - program documentation - msaccess - ms access - microsoft access
Contentwise responsible person: 4TOPS, R. Lovelingpad 18, 4103 VD Culemborg, GLD, Netherlands
Mark Uildriks, submissions(at)4tops(dot)com, Phone: +31(0)30 8906655