Query Cross-Reference

This powerful cross-reference report shows where and how each Microsoft Access query is used across your entire database.

In this example, you can see several queries and where they're used. Some are only used once, while others are used in multiple places. This is critical to know before modifying a query for one reference to it. Without knowing where and how the query is used elsewhere, you can easily fix one bug and create new ones.

Within each grouping, the calling object type and name are listed along with the reference property name. Trying to generate this information manually would be extremely timely and inaccurate. Total Access Analyzer examines your entire database as a whole to generate this extensive cross-reference information.

Part of the Unused Query Analysis

Do you have queries you think aren't used, but are afraid to delete because you're not sure? By performing the extensive cross-reference analysis to determine where queries are used, Total Access Analyzer also determines queries that aren't used. A separate Suggestions report lists queries that aren't referenced which are candidates for deletion.

NOTES

• The Resolved? column is checked if the query exists (if it doesn't an error appears in the Error reports).
• The Variable? column is checked if a variable containing a query name is referenced in code.