You have determined you need to use the Scan and Repair function of the ACT! Data Diagnostic Tool (ACTDIAG) to repair a database and would like to know how to proceed.
If you believe your database is damaged, it is recommended that you first refer to the following document for more information about repairing your database:
Note: These steps are for ACTDiag that come with ACT! 5.0.4.x through 6.0.2.x. If you do not have one of those versions you will need to update you ACT! software.
Disclaimer: This article was
written about products for which Sage Software, Inc. no longer offers support.
Therefore, this article is offered “as is” and will no longer be updated. If
you need assistance with issues pertaining to an unsupported product, please
refer your questions to the
ACT! Online Community or to an
ACT!
Certified Consultant. For more information regarding currently
supported versions of ACT!, please see our
Obsolescence
Policy
If you believe your database is damaged, it is recommended that you first refer to the following document for more information about repairing your database:
-
Title : I Suspect My Database is Damaged. How Do I Repair
It?
I Suspect My Database is Damaged. How Do I Repair It?
-
Title : ACTDIAG: The ACT! Data Diagnostic Tool
ACT!Diag--The ACT! Data Diagnostic Tool
Note: These steps are for ACTDiag that come with ACT! 5.0.4.x through 6.0.2.x. If you do not have one of those versions you will need to update you ACT! software.
- Exit ACT!
- Click the Windows Start button, and then click Run. The Run dialog appears.
- Type actdiag into the Open field, then click OK. The ACT! Data Diagnostic Tool appears.
- Click the Maintenance menu, and then click Scan and Repair Database.
- You will see the following dialog. You must click
Yes to continue.
The backup will be created automatically once you open the correct database.
- You will then be prompted to open the database you want to scan and repair. Select the 'problem' database, and then click Open. (If the database is not in the default database directory, you will need to navigate to the database first)
- A backup of the database will be made. The backup file (in ZIP format) will be placed in the same folder as the database. The filename of the backup will be the name of the database followed by some numbers and a .zip extension. (the numbers represent a time stamp)
- When the backup is complete, the
Backup completed dialog
appears (as illustrated below). Click Close.
- The next dialog box asks you to click the appropriate User as the Record Manager for the ACTDIAG repair records. ACTDIAG repair records are contacts created if ACTDIAG finds any records that have an incorrect or unknown record manager. The user you click in this list will become the record manager of the ACTDIAG repair records. After selecting the appropriate record manager, click OK, then click Yes to continue. ACTDIAG will start the process of scanning and, if necessary, repairing your database.
- When the Scan and Repair
process has completed, you will see the following
ACT! Data Diagnostic Tool
message. Click the link to see the repair log
of your database if desired. The repair log
will open as a text document in Windows Notepad. The repair log contains
all of the issues that were found in the Scan and Repair process, and what
(if anything) was done to fix them. Clicking the second link will take you
to the ACT! Database Services, Database Repair Web site.
- Click OK.
The following ACT! Data Diagnostic Tool
dialog box appears.
- If all green check marks are displayed, click
Close, and then
exit ACTDIAG. If any red checkmarks are displayed,
repeat the Scan and Repair
procedure until all green check marks are displayed.
Note: If red check marks remain after three repetitions of this procedure, it is unlikely that continuing to repeat the Scan and Repair will manifest further repairs. Please click the link at the end of this document for information regarding database repair:
- Launch ACT! and open the database. You will see the
following ACT!
dialog box (because the scan and repair also deletes
the index files). Click Yes
and ACT! will rebuild the index files and open your database.
This may take some time depending on the size of the database.
- Once your database open, click the File menu, point to Administration, and then click Database Maintenance. The Database Maintenance dialog box appears.
- Ensure the Compress Database check box is enabled, and then click Reindex. Your database will compress and reindex.
- Once completed if your this had not resolved your issue, you may need to contact an ACT! Certified Consultant (ACC) for information regarding ACT! 6.x or prior database repair. A listing of ACC's that specialize in these repairs can be found on our website: Database Services