Microsoft Access

Access database(*.mdb).

The Microsoft Office Access tool by the Microsoft company can be used for databse and table management. It is typically included in the Microsoft Office Professional (and higher) and combines the relation Microsoft Jet Database Engine with graphic user inteface. This tool 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 PmDatabase.CompactDatabase method.
- Definition of 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, which means with respect to the size of the column data type (e.g. to opt the size of a text column according to real needs).
- The total number of columns is limited in the table (hundreds by order).
The database can be filled:
- by the PmTrend object, if the Storage type configurator is set in this object to Database Access cyclic or Database Access backups (obsolete)
- by the PmAdo object
- by the PmDatabase (obsolete) object via named ODBC source
For next descriptions to the Microsoft Access, see:
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice