Community
Showing results for 
Search instead for 
Do you mean 
Reply

Need Assistance with Converting from act 6 to 2010 premium

New Member
Posts: 4
Country: USA

Need Assistance with Converting from act 6 to 2010 premium

Hi,

 

I need help! I'm trying to convert a data base from act 6 to 2010 premium. I've already converted serveral other data bases but I can't convert one. The problem I encounter is.

 

Violation of PRIMARY KEY constraint 'TBL_GROU_CONTACT_PK'.

Cannot insert duplicate key in object

'dbo.TBL_GROUP_CONTAT'.

The statement has been terminated.

 

I have no idea what this means. I haven't encountered any problems with 7 other data sources that I've converted. Please help.

 

Thank you

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Need Assistance with Converting from act 6 to 2010 premium

Hello Yenwen,

Welcome to the Act! Online Community!

 

It appears this particular V6 database damaged.  Here is an article with steps to take to repair your database: KB Article 11462

The 'Scan and Repair' step is the main one.  Another option is to save a copy of the V6 database to a new name, run the Scan and Repair step, then attempt conversion.

 

Greg Martin
Sage
Copper Contributor
Posts: 28
Country: USA

Re: Need Assistance with Converting from act 6 to 2010 premium

Save a empty copy of your database. This will separate your data from your field definitions. If the empty copy converts then you have a problem in the data. If the empty copy will not convert then you have a problem in your fields.

New Member
Posts: 4
Country: USA

Re: Need Assistance with Converting from act 6 to 2010 premium

Thank you guys very much. I'll be giving that a try immediately