Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2010, 07:02 AM
ajayjairth ajayjairth is offline How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr Windows 7 How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr Office 2007
Novice
How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr
 
Join Date: May 2010
Posts: 1
ajayjairth is on a distinguished road
Default How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr

i have to upgrade Small Buisness accounting 2006 Professional to Microsoft Office accounting 2009 professional by retaining the 2006 company file data.

Can anybody help me to upgrade it?
I have already tried backup and restor the company file from 2006 version to 2009. it restored the file successfully. when i tried to open the the restored file in Microsoft Office accounting 2009 ,it asked me to upgrade the file and i followed the wizard steps. while upgrading the data it gives error and upgrade process failed with error. following is the error i have found in the log file.
<Comment>Alter AccountRegisterLineID to not nullable</Comment>
<SqlCommand><SqlString> ALTER TABLE ReconciledBankCreditCardTransactionTable ALTER COLUMN AccountRegisterLineID INT NOT NULL
</SqlString></SqlCommand><ResultFailure><Exception>System.Data.S qlClient.SqlException: Cannot insert the value NULL into column 'AccountRegisterLineID', table 'MyCompnayData.dbo.ReconciledBankCreditCardTransac tionTable'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.BusinessSolutions.SmallBusinessAccountin g.DBUpgradeShell.ExecuteRunSql(String comment, String SqlString, Boolean raiseEvent, Boolean skipLog)</Exception></ResultFailure></Command>
<Command TimeTaken="00:00:00.0048830" StartTime="5/26/2010 11:52:55 AM" Sequence="18285>
<Comment>Marking database as invalid</Comment>
<SqlCommand><SqlString>UPDATE VersionInfoTable SET DatabaseState = 2</SqlString></SqlCommand><ResultSuccess>number of rows = "1"</ResultSuccess></Command>


<Comment Time="5/26/2010 11:52:55 AM">Db upgrade failed.</Comment>
<Comment Time="5/26/2010 11:52:55 AM">System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'AccountRegisterLineID', table 'MyCompnayData.dbo.ReconciledBankCreditCardTransac tionTable'; column does not allow nulls. UPDATE fails.
MyCompnayData is the database name generated by the upgrde process
I have also read articles on upgrading from 2006 to 2009 , everybody recommend for microsoft free upgrde at
http://www.ideawins.com/Upgrade.aspx. but this lonk is not working.
plese help me sort out the above problem
Thanks in advance
Reply With Quote
Reply

Tags
accounting, office accounting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr Will Microsoft Office 2010 Offer an Upgrade Version? benjo Office 4 06-08-2010 04:06 PM
Works 9 Upgrade to Office 2007 Standard TXJAWA Office 0 05-03-2010 07:49 AM
How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr Upgrading an older Office upgrade aterry51 Office 1 01-16-2010 05:50 AM
How to Upgrade Small buissness accountion 2006 to Microsoft Office accounting 2009 pr Downgrading the from Office Small Business 2003 to Office standard 2003 RockyPaolo Office 3 05-14-2009 12:09 AM
Product Key for MS Office 2000 Small Business Edition darmstadtrunner Office 0 12-28-2005 03:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft