All editions of can use an Access 2000 database to store data. The product creates file formats that use the .mdb file extension.
: The physical size limit set by Microsoft to this type of files is 2 GB (2,048 MB).
a) Software requirements
There are no specific software requirements for creating and managing an Access database using . Installing Microsoft Access on the workstation is not required.
- By default, PROMODAG Reports creates Access databases in the user's profile, see Default paths for installation and settings.
- PROMODAG Reports also uses the default TEMP environment variable while compacting the database and creates a copy of the database into the \Temp directory. Make sure that this \Temp directory is located on a drive whose free space is greater than the database size.
No specific permission is required if you do not plan to share the Access database.
If you plan to share the Access database, the .mdb file should be located in a folder where users have read, write, create, and delete privileges. Even if you want users to have different file privileges (for example, some read-only and some read-write), all users sharing a database must have read, write, and create permissions to the folder. You can, however, assign read-only permissions to the .mdb file for individual users while still allowing full permissions to the folder.
B. Database files
Data is stored in the .mdb file.
- For every database opened for shared use, an .ldb file is created to store computer and security names and to place extended byte range locks. The .ldb file always has the same name as the opened database (.mdb) and is located in the same folder as the opened database.
The Jet database engine uses .ldb file information to prevent users from writing data to pages that other users have locked and to determine who has other pages locked.
Microsoft Access databases are uniquely designed to allow databases to consistently increase in size, unless you compact them. When you delete a record from a Microsoft Access database, the space allotted for that record continues to be held in reserve by the database and it is not released for reuse. If you never compact your Microsoft Access database, your database will retain the "wasted" space and continue to consume additional space to accommodate additional data. To avoid generating excess amounts of wasted space and corrupting your database, you must compact your database periodically.
PROMODAG Reports does not manage database backup tasks. Therefore, we recommend you to backup your database regularly.
C. How does PROMODAG Reports use the Access database
PROMODAG Reports uses the database to permanently store the data it needs to generate reports.
Data are collected and added to the database during message tracking file imports. The database will keep on growing unless you decide to clear data using the Tools > Purge Data Imports option in PROMODAG Reports.
Database size limitation and potential problems
: You should purge and compact your database once it has approximately reached 1.8 GB in size, i.e. 90% of the 2 GB size limit, or to create a new one.
If not, the database may be trying to expand beyond 2 GB due to temporary tables created by PROMODAG Reports while it generates reports. In this case, you will receive various error messages.