User`s guide

21-0381E v4.7.4
Welcome Report Control Admin Sys Config
Tech-Ref
289
to be managed under SQL server, you will be
prompted automatically for this during the
installation. With a typical system (i.e., NOT
using SQL server), you'll need to set this
through the table repair utility.
Details / Steps: See "User-Logins" (previous).
Auto-User Update (ERM Integration)
: This feature uses
the "Import
UserLogin' instead for any tasks involving
the 'ErmUserImport' and 'ErmUserImportResult' tables.
Linking to the Database to Generate
Custom Queries and Reports
The following example and screens pertain to
using MS Access to link to the database.
1) In MS Access, open the File menu, and
select N
ew. Tip: From now on, I'll condense
menu selections (e.g., F
ile, New).
Double-click "Database".
2) In the next screen, give it a suitable name.
Then, click [Create].
3) Select: File, Get External Data, Link
Tables like this:
4) You can ignore most of this screen.
At the very bottom, open the "Files of type"
field [], and select "ODBC Databases ()".
5) You can ignore most of this one, too:
Just select Machine Data Source at the
top, and click [ New ].