Microsoft Access Query Cross-Reference

This report answers the critical question:

Where are my Microsoft Access queries used and referenced?

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. See Finding and Deleting Unused Access Objects and Code for more details.

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.

Additional Resources

• Summary List of Total Access Analyzer Reports
• Complete List of Total Access Analyzer Reports
• Best Practices for Microsoft Access Database Development