Transaction Tracking
The Enterprise Version of AccuBuild does not limit the transaction tracking feature to 250 records as does the BDE Version of AccuBuild. Therefore, the options to disable the transaction tracking found in the Company Configuration Settings and the Trucking Properties have been removed in the Enterprise Version. If the batch contains more than 7000 records, then the transaction tracking may be temporarily disabled on the Help Menu. Please contact AccuBuild's support staff for more information on permanently changing the maximum number of records that may be posted within a single batch.
Indexing Tables
The Advantage Database Server is much more robust than the Borland Database Engine (BDE) and the chances of an index corruption are a lot less. Therefore, the Enterprise version does NOT have separate indexing menu option for each module. The only options for indexing tables in the Enterprise Version are found on the File Menu to index the Company Tables, User Tables, or System Tables.
Note: Company tables may be indexed while other users are logged into a different company in the Enterprise Version of AccuBuild. In the BDE Version, all users had to exit the system before the company tables could be indexed.
Table Structure Updates
The AccuBuild Enterprise Version must always ensure that the Database Version is synchronized with the AccuBuild Program Version. This synchronization process compares the Major and Minor Versions of the Database to the Major and Minor Versions of the program. For example, if the program version is 8.3 and the Database Version is 8.2, the system would update the database automatically by applying a SQL Update script to the ADS DataBase Server. If the database is out of sync by several versions, then the Update scripts are applied sequentially in order until the Database Version and the Program Version are the same. If the update scripts cannot be applied successfully, the program will be closed down until the updates are applied correctly.
There are three separate databases in the AccuBuild System: Global Database, Company Database, and User Database. The Global Database consists of the tables located in the Data Folder under the AccuBuild Program Folder. The company and user databases are made up of the tables located in the specific company and user folders respectively.
The Database Definitions and update scripts are stored in the ADSDict Folder under the AccuBuild Program Folder and are named as follows:
DataBase Dictionary Files:
BaseGlob Global Database definition files.
BaseComp Company Database definition files.
BaseUser User Database definition files.
DataBase Update Script Files:
CRM_m.sql Company Database Update Script
GRM_m.sql Global Database Update Script
URM_m.sql User Database Update Script
Where M=Major Version and m=Minor Version.
For example CR8_2.sql is the updated script to change from 8.1 to 8.2 Database
The update scripts are applied at the server and the AccuBuild program will attempt to make a zip backup of the database prior to applying any update scripts. The backup files will be named according to the Database Version being backed up. For example GR8_2A.ZIP would represent the Global Database (GR) Version 8.2. The Global Databases are backed up in the Data Folder, the Company Databases (CR) are kept in the company folder, and the User Databases (UR) are kept in the user folder.
|