What is Query Analyzer

Query Analyzer is a Microsoft Access v2.0, 95 and 97 add-in to explore and develop query structures.

Main function of QA is displaying query hierarchy, i.e. which query uses which tables/queries. Other functionality (such as navigation, invoking query builder etc.) is built around this feature.

Query Analyzer was created as auxiliary tool while developing complex Access database (about 300 queries with multiplicity level up to 8) and proved to be means of improving both performance and quality of query programming.

We hope that Query Analyzer will help other developers to investigate, develop and support complex Microsoft Access query structures.

Installation

Use Add-In Manager to install Query Analyzer. Launch Add-In Manager and select QAxx.MDA corresponding to version of Access you are using: QA20 for Access 2.0, QA95 for Access95, QA97 for Access97.

After installation you’ll find appropriate item in the add-in menu.

If you prefer to install add-ins manually, use sm_qa_Main() as entry point.

You can open QAxx.MDA database prior to installing it as add-in. Press Ctrl-Q, and QA main window will pop up, showing you query structure of QA itself. We recommend starting with browsing some already familiar query structure though.

For your convenience you can create AutoKeys macro in database to be explored and set keyboard shortcut (Ctrl-Q for example) to invoke QA by calling sm_qa_Main() function. You can import this macro from QA.

Legal notice

Authors are not responsible of results of use or inability to use Query Analyzer program. You are using the program at your own risk.

Query Analyzer is distributed freely and without limitations.

Copyright (c) Business Russia Ltd.

New versions

<eof>