Article ID: 939556
Article Last Modified on 8/15/2007
APPLIES TO
- Microsoft Office Accounting Professional 2007
- Microsoft Office Accounting Express 2007
- Microsoft Office Small Business Accounting 2006
SYMPTOMS
If you try to upgrade a company from Microsoft Small Business Accounting 2006 to Microsoft Office Accounting Professional 2007 or to Microsoft Office Accounting Express 2007, you receive the following error message:
This problem occurs when the update process starts.
CAUSE
This problem may occur because the company program file is still associated with Microsoft Small Business Accounting 2006 even though Microsoft Small Business Accounting 2006 was uninstalled from the computer.
Note The company program file appears as an .sbc file.
RESOLUTION
To resolve this problem, use one of the following methods.
Method 1: Upgrade the database
- Start Accounting Professional 2007 or Accounting Express 2007.
- In the "Start - Microsoft Office Accounting" window, click Restore a backup.
- In the Database Restore dialog box, select Browse next to the Backup filename box.
- Click Backup File to Restore. Then, click Version 1.0 Backup files (*.zip) in the Files of type box.
- Select the backup file that you want to restore. Then, click Open.
- In the Database Restore dialog box, click Browse next to the Restore backup file to box.
- Select the .sbc file that you tried to open when you received error message. Then, click Save.
- Click Yes if you are prompted by the following message:
- Click OK if you receive the following message:
- Start Accounting Professional 2007 or Accounting Express 2007.
- In the "Start - Microsoft Office Accounting" window, click Open an existing company, and then click the company program file that you selected in step 7 of this method.
- Follow the steps in the Update wizard to complete the update.
Method 2: Attach the company database file
- Start Data Tools. To do this, use the appropriate step:
- Accounting Professional 2007 or Accounting Express 2007
Click Start, point to All Programs, point to Microsoft Office, point to Microsoft Office Accounting 2007 Tools, and then click Data Tools. - Microsoft Small Business Accounting 2006
Click Start, point to All Programs, point to Microsoft Small Business Accounting, and then click Data Tools.
- Accounting Professional 2007 or Accounting Express 2007
- In the Microsoft Office Accounting Data Utilities dialog box or in the Small Business Accounting Data Tools dialog box, click the Advanced Tools tab.
- Click Attach.
- In the Attach a Database dialog box, click Browse, locate the company database file that you want to attach, and then click Open.
Notes- The company database file appears as an .sbd file.
- By default in Microsoft Small Business Accounting 2006, the data files are in the following location:
C:\program files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data
- In the Database name box, type a name that you want to use for the new company database file, and then click to select the Create new company file (.sbc) that links to this database check box.
- Click Attach.
- Click OK.
- Click Close.
- Start Accounting Professional 2007 or Accounting Express 2007.
- In the "Start - Microsoft Office Accounting" window, click Open an existing company, and then click the company program file that you created in step 5 of this method.
- Follow the steps in the Update wizard to complete the update.
Keywords: kberrmsg kbtshoot kbprb kbmbsmigrate kbexpertiseinter kbexpertisebeginner KB939556