Tips for converting ACT! 6.0 (or earlier) databases to ACT! by Sage

The most common problem with converting the older versions of ACT! to ACT! by Sage is if there is some damage in the database. Unfortunately, the older versions could become corrupt but not be noticed if you didn’t access that part of the data. As everything needs to be read for a conversion or sync, these functions can show up issues that might have been there for some time.

First, no-matter which version you have, make sure you have a backup of the data before you start.

You should also make sure you have the User Name and Password for someone with Administrator access to the database.

Because the repair tools were improved could fix more types of damage as the versions progressed, I recommend always upgrading earlier databases to ACT! 6.0 and cleaning them there before converting to ACT! by Sage.

If you don’t have ACT! 6.0, you can download the ACT! 6.0 30-day Trial – this will give you the time to convert, clean and repair your database to ready it for converting to the later versions.

Convert Earlier Versions to ACT! 6.0

Always perform a database compress and reindex in the version you have before going to ACT! 6.0. The steps for that conversion depends on how old your version is:

Repair and Clean the ACT! 6.0 Database

Next you should do a repair with ACTDIAG as per:
How To Use The ACT! Data Diagnostic Tool (ACTDIAG) to Scan and Repair a Database

If you already have a later version installed, you’ll need to start ACTDIAG as per:
How to Use the ACT! 6.0 Diagnostic Tool When a Later Edition of ACT! is also Installed

Please note: If you got any red check marks, keep running it till they show all green
But if you’re still getting red checks after 3-4 runs, you’ll need to use additional tools to repair it
or have it professionally repaired

If getting an ACT! Consultant to help you with the conversion (recommended)
I also recommend that they run ABC_Scan on the database

If you are having problems are want to be really sure about your data, I recommend:
Red Flags from Cornerstone Solutions

If it still won’t clean or the conversion below still fails, please contact GL Computing

Centralising Attached Files

If you have attached files, especially if they are stored in different locations or on local workstations on a LAN, you should move these to one folder. You will then need to adjust the links in the database to show the new location. There are a number of tools to do this, I personally use Oak!Check! – Validate Attachments. You can also use it to do any other data cleaning you might need.

Converting to ACT! 2010

You are now ready to install ACT! 2010 as per: Sharing ACT! – Network or Sync (Part 1)

Which ever version of ACT! you are converting to, make sure you have the latest build and Hotfix. At the time of this article, for ACT! 2010, this is 12.0 Hotfix 4. It has some fixes for converting some databases. See: How to Download and Apply the ACT! by Sage 2010 Hot Fix 4

Then you should just be able to open the database from ACT! 2010 and it will convert. See:
How to Convert an ACT! 3.x, 4.x, 5.x (2000) or 6.x (2004) Database to ACT! by Sage 2010

If you have any questions, please post a comment here or in the LinkedIN ACT! Fanatics Group 

Technorati Tags: ,,,,