Microsoft Access

Access database (*.mdb). The Microsoft Office Access software by the Microsoft company can be used for database and table management. It is usually included in the Microsoft Office Professional (and higher) and combines the relation Microsoft Jet Database Engine with graphic user inteface. This software is not neccessary for using the database in the PROMOTIC system.

Work with Access database
- If records are added into a table and at a time they are deleted when working with the table of the Access database, then the situation can occur when the size of occupied disk space increases while the number of table records is constant. In such case it is suitable from time to time to defragment all database tables by the PmaDatabase.CompactDatabase method.
- Definition of the table structure: A draft of the table structure is limited by the data size of one row to 2 kB. With great number of columns in the table it is necessary to opt column types in the table in an optimized way, i.e. with respect to the size of the column data type (e.g. to opt the size of the String type column according to real needs).
- The total number of columns in the table is limited (hundreds by order).

The database can be filled:
- by the PmaTrendGroup object, if in this object the "Storage type" configurator is set to Database Access cyclic or Database Access backups (obsolete)
- by the PmaAdo object
- by the PmaDatabase object (obsolete) via named ODBC source

For next descriptions to the Microsoft Access, see:
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.