ACCPAC Migration v5.2 to v5.4

I am facing a problem during the upgrade Accpac 5.2 to Accpac 5.4.

After the activation of AR, the message shown “Unable to modify ARCMM” & "Error converting table ARCMM".

I had checked the table ARCMM, it added the column “TEXTCMNT1” to “TEXTCMNT10”. However the value is NULL.

I had tested the same environment use sample company and it works fine in the activation.

I am using SQL Server 2014 to doing the conversion.

Is it possible that the data size is too large to cause SQL Server Command Timeout?

  • 0

    Set the SQL database compatibility to the lowest level: right-click the SQL database > Properties > Options > Compatibility Level
    You can set it higher once you complete your upgrades.

    You may also need to use an older version SQL client, I can't remember since its been a while that I've gone that far back.