|
|
|
|
The WinSieve program has been designed around the concept of projects. A schematic of the database structure is shown on the next page followed by a detailed description of all the data fields. This data storage method allows for the expansion, archival, and network administration of a large number of projects.
Using this method a separate Microsoft Access 97 database is used to store each project for each application. Each project is stored in a separate directory, which can be on the same computer or spread across a network. The number of databases for each project will depend upon the applications being used for that project. If for example, the WinLoG and WinSieve programs are being used with the project, there will be two project databases
The names of the project databases are the project number combined with the application suffix. For example, if the project number were "A980205" then the project database name of the WinSieve data would be "A980205winsieve.mdb". Typically, this project would be stored in the subdirectory "\A980205".
A master project database, also in Microsoft Access 97 format, is used to keep track of the projects and their locations on the network. This master project database is also used to store data (such as symbol libraries and text macros) that is common to all projects and applications. The name of the project master database is "gaeaprojects.mdb". The database is stored in a directory specified by the user when the program is installed.
In addition to the master project database, separate application master databases are used to store data that is common to all projects but specific to the application. A WinSieve master database is used to store templates and legends, which can be accessed by all projects. The name of this database is "winsieve.mdb". All of the application master databases are stored in the same directory as the master project database.
If the master databases are moved, the "Master Database Directory" in the program preferences must be changed to reflect the new directory.