Query Structure Reporter

for MS Access 97, 2K, XP

version 1.4

by Alex Walker, 2003

What is Query Structure Reporter (QSR)

This is an add-in for MS Access designed for exploring query structure of an Access database. QSR makes it easy to examine the relationship between nested queries, i.e. which query uses which table/query. The dependency tree of the queries of your database is put on the Excel worksheet where you may drag-and-drop each object (query or table) to make the hierarchy view clear and easy to understand, all the changes in the view are remembered for future viewing.

Screenshots

How to install

1. Download QSRv1.4.zip.
2. Unpack version of the add-in corresponding to version of Access you are using.
3. Open any Access database.
4. Launch Add-in Manager from Tools->Add-ins 
5. Select add-in file and then close Add-in Manager.

To start QSR click the item "Query Structure Reporter" from Tools->Add-ins. Press button "About" on the main form  for detail information about using the add-in.

Limitations

The add-in will not be able to process databases with more then about 250 tables/queries because of Excel limitations. 

Unregistered add-in will not show Insert, Update and Delete queries.

How to register

Every time starting the unregistered add-in you will see window with the registration number. Please enter it in the order form and get the password.

I hope my add-in will be useful for you.

Thank you for your attention.

Alex Walker

QSR@swissinfo.org