The Advanced Access Code options allow the choice of where the Access Code for a user is stored.

1. Use the Access Code specified in User Settings

   This choice simply uses the Access Code as entered on the User Settings ~ User page.

2. Access Code stored in a database

   This choice allows the use of an ODBC database lookup to retrieve the Access Code for the user.

   To successfully retrieve the Access Code value from the database the following fields must be defined:

   • Database Data Source Name (DSN)
     
     The DSN the specifies the database to connect to. (Note: This must be a System DSN.)
   • Database User Name
     
     The database user account name to use to connect to the database.
   • Database Password
     
     The password for the database user account.
   • Database table
     
     Look up this database table for the Dictator ID.
   • Column to match Access Code
     
     The database column that contains the Access Code.
   • Column to return Dictator ID
     
     The column containing the Dictator ID to return.

   These values will be used to create a query in the form:

   SELECT Dictator ID FROM Table WHERE Access Code = 'access code value'

   Use the [Test] button to test the database connection and that the expected value is returned from the database query.

   For more go to Database Test.

Restore

The [Restore] button will set the option to Use the Access Code specified in User Settings and clear all other fields on this page.

See also:
User Settings ~ User
Settings