Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error converting 6.0 database to 2010

Accepted Solution Solved
New Member
Posts: 2
Country: United States
Accepted Solution

Error converting 6.0 database to 2010

I'm converting a very simple database from version 6.0 to 2010, and I get the following error in the Conversion Details:

--

Updating database...
  Added First Name Prefix: Don
  Added First Name Prefix: Dona
  Added Last Name Prefix: van den
  Added Last Name Prefix: van der
  Added Last Name Prefix: von der
Converting Contacts...
       1861 of 1861 converted.
Converting Users...
       9 of 9 converted.
Converting Groups...
       94 of 94 converted.
Converting Activities...
The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.

--

 

Can anyone shed some light on a possible solution?

Thank you,

 Lucas


Accepted Solutions
Solution
Accepted by topic author progressivetech
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Error converting 6.0 database to 2010

Simple or not the database has corruption in the activities table and needs  to be sent to database repair.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author progressivetech
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Error converting 6.0 database to 2010

Simple or not the database has corruption in the activities table and needs  to be sent to database repair.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 2
Country: United States

Re: Error converting 6.0 database to 2010

Thank you.

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Error converting 6.0 database to 2010

Lucas,

You can also try the solutions suggested in the following Knowledgebase article:

 

Error: "The conversion from datetime data type to smalldatetime data type resulted in a smalldatetim...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.