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
PmaDatabase object (obsolete) via named
ODBC source
For next descriptions to the
Microsoft Access, see: