Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals.
Does Total Access Analyzer support documentation of Pass-Through Queries?
Total Access Analyzer documents and parses the SQL to perform object cross-referencing. This works for standard Access queries, however the SQL parser is not entirely accurate for Pass-Through queries. Pass-Through queries are sent to SQL Server to run on the tables there. Consequently, the Microsoft Access database can't see those tables; so when Total Access Analyzer performs its cross-reference on the query's SQL it can’t cross-reference those tables correctly. In this case, ignore the cross-reference errors that are reported by Total Access Analyzer, but be sure to manually check to ensure that your Pass-Through queries are valid.
Note that if you have links to those tables (using the same names as how they are referenced in the pass-through query), then the SQL parser in Total Access Analyzer should resolve them.
Please sign in to leave a comment.