
278
MONITOR AFx™ Director V4.1 User's Guide
500-9041 v4.1
Introduction
Director's "Database Query" feature allows you
(or your custom software) to link to the
database, and view or use the data as desired.
This may be used to integrate with an ERM
system, and/or to run custom reports (e.g.,
setting up your own custom queries in MS
Access, or using a program such as "Crystal
Reports".
Notice: Read-only 'views' are provided as well. To
generate custom queries and reports, you need to
create a new (blank) database, and link to the
Director database as discussed below.
Required Software Version and
Licensing
The "Database Query" feature requires
MONITOR AFx Director software
V4.10
or
newer, with "
Elite
" or "
Elite+
" software
licensing.
Note:
You will see "
Database
Query
" authority in the license manager utility.
Activating "Database Query" for a
Closed Database System
"Query User Login" information is required for
this feature. In an open database system, you
are prompted automatically for this during the
installation. With a "Closed Database" (typical)
system, you'll need to set this through the table
repair utility. (For details, see a previous topic
/ above.)
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
New
.
Tip:
From now on, I'll condense menu selections
(e.g.,
File
,
N
ew
).
Double-click "Database".
2)
In the next screen, give it a suitable name.
Then, click
[Create]
.
Linking to the Database
(Used for: Custom Query/Reporting; ERM Integration)
Comentarios a estos manuales