Page tree

Power surges, network issues, and hardware failure can contribute to data corruption. To fix this, you can repair your DBISam tables.

Since this could result in data loss, make a backup of either the People or Financial Suite (depending on where the error displays) before repairing tables. In addition, everyone in your organization must exit ACS.

DBISam tables have 3 files, .acsdat (data), .acsidx (index) and .acsblb (memo).

When a DBISam table is rebuilt in table maintenance, the original table is backed up. The backup of the original table has the extensions .acsibk, .acsbk and .acsdbk.

 To perform a people backup
 
  1. Make sure all ACS users are logged out of all ACS Desktop Products before performing the backup.
  2. On the Windows taskbar, click Start Programs > ACS Technologies > ACS Tools.
  3. Click ACS Backup, then log in using your ACS user name and password.
  4. Under Data Options, select People Data Backup.
  5. Optional: Under Additional Options, select Verify Backup.
  6. Under Configuration, note the Backup Destination Directory. To change the location, click Lookup .
  7. Click Backup
  8. In the Select Datasets window, clear any datasets you do not want to back up. We recommend backing up all datasets in each backup in case your data needs to be repaired, but if you include pictures, the backup may be very large.

  9. Click OK.

 

 To perform a financial backup
 
  1. Make sure all ACS users are logged out of all ACS Desktop Products before performing the backup.
  2. On the Windows taskbar, click Start Programs > ACS Technologies > ACS Tools.
  3. Click ACS Backup, then log in using your ACS user name and password.
  4. Under Data Options, select Financial Data Backup.
  5. Optional: Under Additional Options, select Verify Backup.
  6. Under Configuration, note the Backup Destination Directory. To change the location, click Lookup .
  7. Click Backup
  8. In the Select Datasets window, clear any datasets you do not want to back up, then click OK.

 

 To verify and repair corrupt DBISam tables
  1. On the Windows taskbar, click Start > Programs ACS Technologies > ACS Tools Utility Manager
  2. Click Table Maintenance
  3. Enter your ACS user name and password, then click OK
  4. Under Tables, select PeopleFinancials or System.
  5. If you use multiple People or Financial datasets,select the appropriate datasets to repair.
  6. Click Repair All Tables. If you need to repair a single table, locate and select the table, then click Repair Table
  7. If a confirmation message displays, click Yes to continue, then click OK.
  8. At the end of the process, the system displays a list of the repaired tables. To print this list, click File, then Print.
  9. Click Close, then Exit.