01-28-2009 02:06 PM
When I migrate ACT 2000 to ACT 2007 by opening the .dbf file with ACT 2007, I get error when the migration reaches Notes and Histories (The Contacts and Groups tables seem to be ok) . The error is ' The INSERT Statement conflicted with the Foreign Key Constraint 'NOTE_CREATEUSERID_FK'. This terminates the migration. Possibly there is some corruption in the ACT 2000 database. Running a database repair (with the diagnostic tool, actdiag.exe) did not help. One approach (which I have not tried yet) is to create an empty database with ACT 2000 and create an identical database structure for the Contacts and Groups tables. Then import the corrupt database into the empty database. Reasoning here is that creating a new database will remove the corruption. I am unsure if the corruption in Notes and Histories will carry forward because in this approach we are essentially recreating the Contacts and Groups (not Notes and Histories). I was wondering if there is an alternate way out of this.
01-28-2009 02:22 PM
01-28-2009 02:30 PM
01-28-2009 04:28 PM
While I will try RedFlags, I was wondering if there is some way to read a .ADF file. When the database wizard (of ACT 2007) started migration, I cancelled out and got a large .ADF file (along with some other files). I believe the .ADF holds the entire database (with some corrupt records in Notes and Histories tables, of course). I could try reading-in the database file with ACT 2007 (and I am sure that it would barf when reading the Notes and Histories). Any suggestion if there is some other software that could read the .ADF or alternate routes that I could take to parse the .ADF? Thanks.