The Microsoft Office Access
software by the Microsoft
company can be used for database 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 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 PmDatabase.CompactDatabase
- 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, i.e. 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 PmDatabase
(obsolete) object via named ODBC
For next descriptions to the Microsoft Access