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, 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.
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.
This can be done in either of the following ways:
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 v9). 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. The user will be able to change the options during their AQT session, however these will be set back to the values in aqtoptions.txt the next time AQT starts.
If an option is locked its value cannot be changed from the startup file.