Metrix Files and Technical Components

See also:

• Installation Guide Introduction
• Introduction to METRIX
• Understanding Interactions and Custom Tables
• Understanding METRIX Tables and Relationships

Metrix consists of several components, each of which serves a specific purpose:

• Metrix.adp. This is a Microsoft Access project file that contains most of the major user interface ("front-end") elements. In most cases, the file is stored locally on the user's computer.
• interactsql.adp. This is a Microsoft Access project file that contains customizations to the standard Metrix installation. Custom forms and populated custom tables reside in this file. The file is stored on a network-accessible location, and each user's Metrix.adp file will be configured to connect to it.
• reportsql.adp. This is a Microsoft Access project file that contains customizations to the standard Metrix installation. Specifically, it contains custom reports accessible by each Metrix user. The file is stored on a network-accessible location, and each user's Metrix.adp file will be configured to connect to it.
• devmodule.mdb. This is a Microsoft Access database separate from the core Metrix installation. It is used by developers and administrators to create or import custom tables; configure them; and migrate them into Metrix.
• Metrix database. The data repository is a Microsoft SQL Server/MSDE database. It resides on a server, and each user's .adp files are configured to connect to it. The database contains hundreds of stored procedures, tables and views and that enable data retrieval and manipulation.
• Programming logic. Each .adp file contains a significant number of modules written in Visual Basic for Applications, the scripting language native to many Microsoft products.