Previous Topic

Next Topic

Book Contents

Book Index

Technical Notes on Options

Registry

All AQT options are held in the Windows registry in the registry key "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Cardett\Options".

For AQT v8, most of the options were held in registry values List1 and List3. For AQT v9 and v10, the settings are held as one registry value per option. This makes it easier to manage the settings through the registry.

An option only appears in the registry when it has a value different from the default.

Locking an Option

System administrators can "lock" an option by placing an entry for it in "HKEY_LOCAL_MACHINE\SOFTWARE\Cardett\AQT\Options".

Once an option is locked, it will appeared "grayed-out" in the Options window - the user will not be able to change it. AQT provides no mechanism to manage the options in this part of the registry - this can only be done by the use of regedit and importing / exporting registry values.

Moving Options between Machines

This can be done in either of the following ways:

Loading Options on AQT Startup

AQT can load an options file when it starts. The file must be called aqtoptions.txt, and located in the the same directory as the AQT executable (eg. C:\Program Files\Advanced Query Tool v10). This file must be in the same format as created by File > Export from the Options window.

This provides an easy way for system administrators to deploy a set of options to their users.

Unless the locked option is used, the user will be able to change the options during their AQT session; these will not be saved but will be set back to the values in aqtoptions.txt the next time AQT starts.

To lock an option, add the locked keyword after the option. When this is specified, the user will not be able to change the option.

Example:

ReadOnlyMode=y;locked

Internal Name

Each option has an internal name, which is the name AQT uses when storing the option in the registry, and used in the export and import files.

The easiest way to see the internal name, is to (in the Options window):

Alternatively (from the Options window):