SQL strings are used in many places in your Microsoft Access database. In query definitions, the record source of forms and reports, and the row source of combo boxes and list boxes on fields and form/report controls.
Total Access Analyzer performs advanced analysis on your SQL strings to see if duplicates exist across your objects. Duplicates are detected even if you have slight differences with spacing, line breaks, etc.
Duplicate SQL strings are opportunities to eliminate duplicate queries, or create a saved query to share across objects.
This report is under Suggestions, Identical SQL and RecordSources. It is intended to alert you that such duplicates exist and that you have the opportunity to consolidate your SQL.
In this example, two reports are using the same SQL string for its RecordSource:
Version 16.7 for
Microsoft Access 2016
Version 15.7 for
Microsoft Access 2013
Version 14.7 for
Microsoft Access 2010
Version 12.97 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 for
Access 2002 and 2000
"Total Access Analyzer is an amazing product that I've relied on and recommended for years. It's a huge time saver."
Sal Ricciardi, Programming Writer, Microsoft Corporation