Quick Find: Search for:
Total Access Analyzer  

Microsoft Access 2007 Version
is Shipping!

Versions also
available for Access
2003, 2002, and 2000!

Access 97 Version


View all FMS products for Microsoft Access All Access Products

 Analyzer Info:

Total Access Analyzer Brochure (2 pages)
PDF Fact Sheet
(426K)

Take a Tour

Best Practices (Errors, Suggestions, and Performance Tips)

List of Reports

Finding Unused Objects and Code

FAQs


Best Access Add-In
Rave Reviews

 Why Analyzer?

for Users, Developers & Consultants

Compare with Microsoft's Documenter

Convince Your Boss

 


"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

More Reviews

 Additional Info:

Press Release

Check for Updates

License Terms

  

 

Objects with Identical SQL Definitions

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 2007 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.

  • The benefit is the ability to adjust the SQL in one place and have all its dependencies use it.
  • The downside is that a future change for one purpose may trigger a problem elsewhere.

This report is intended to alert you that such duplicates exist and that you have the opportunity to consolidate your SQL.

Microsoft Access Objects with Identical SQL Definitions

Contact Us  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 22 Years of Software Excellence