The Microsoft Access database as a runtime version is included free of charge with the IGSS product. It’s this database that stores process data for use in generating reports on the state of the plant and it stores data on preventive maintenance routines created in the IGSS Maintenance module.
Access database technology is not reliable in cases where the quantity of process data approaches 1 GB, which is the limit for the JET database engine. One clear indication of this limit being reached is seen when sluggish report generation occurs. If no action is taken, loss of data and possible corruption of the whole genhdm.mdb database may result.
One solution would be to install an SQL database, which works together with the JET or Access database already in place. The Hour, Day and Month (HDM) data tables located in the IGSS genhdm.mdb database can be linked to the SQL database. The maintenance routines stored in the mntdb.mdb and IGSS log files can also be linked to an SQL database. This raises the threshold of the amount of data that can be managed without danger of corruption or loss. Located on the IGSS CD is Microsoft's runtime SQL Express, which is an SQL database that may be used free of charge. When using it to store data, the threshold for handling process data is raised to approximately 4 GB. If this limit also is reached, then a full version of an SQL database must be installed.
To see how to install and set up the software, click here SQL Express.