How to move a company database file from one computer to another computer in Accounting Professional, in Accounting Express, or in Small Business Accounting 2006

INTRODUCTION

This article describes how to move a company database file from one computer to another computer in the following products:

• Microsoft Office Accounting Professional

• Microsoft Office Accounting Express

• Microsoft Office Small Business Accounting 2006

More Information

To move a company database file from one computer to another computer, follow these steps.

Note You must have administrator access to attach or to detach a company database file.

1. Install one of the following programs on the computer to which you want to move the company database file:

   • Accounting Professional

   • Accounting Express

   • Small Business Accounting 2006

2. Detach the company database file from the computer that currently has the company database:

   1. Use the appropriate method:

      • If you are using Small Business Accounting 2006, click Start, point to All Programs, point to Microsoft Small Business Accounting, and then click Data Tools.

      • If you are using Accounting Professional or Accounting Express, click Start, point to All Programs, point to Microsoft Office, point to Microsoft Office Accounting 2007 Tools or to Microsoft Office Accounting 2008 Tools, and then click Data Tools.

   2. In the Small Business Accounting Data Tools or Microsoft Office Accounting Data Utilities dialog box, click the Advanced Tools tab.

   3. Click Detach.

   4. In the Detach a Database dialog box, select the company database file that you want to detach.
      
      Note You cannot detach the company database file if the company database file is currently open.

   5. Click Detach.

   6. Click OK.

   7. Click Close to close the Detach a Database dialog box.

   8. Click Close to close the Small Business Accounting Data Tools or Microsoft Office Accounting Data Utilities dialog box.

3. Delete the .sbc file from the computer that has the company database file. By default, the .sbc file is located in the following directory:

   C:\Documents and Settings\UserName\My Documents\Small Business Accounting\Companies Note The UserName placeholder is a placeholder for the actual user name.

4. Copy the .sbd files and the .sbl files to the other computer. To do this, follow these steps:

   1. On the computer that has the detached database files, open the appropriate folder:

      • In Small Business Accounting 2006, open the following folder:

        C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data

      • In Accounting Professional and in Accounting Express, open the following folder:

        C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data

        Note The X placeholder is a placeholder for a number, and this number will vary. To determine the correct number, open the corresponding \MSSQL\Data folders, and then locate the company that you want.

   2. If the computers are networked, copy the .sbd files and the .sbl files to the other computer. If the computers are not networked, copy the files to a disk.

   3. Save the .sbd files and the .sbl files on the other computer in the following folders:

      • In Small Business Accounting 2006, save the files in the following folder:

        C:\Program Files\MSSQL$MICROSOFTSMLBIZ\Data

      • In Accounting Professional and in Accounting Express, save the files in the following folder:

        C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data

5. Attach the company database file on the computer to which you saved the .sbd files and the .sbl files, and then create a new .sbc file. To do this, follow these steps:

   1. Use the appropriate method:

      • If you are using Small Business Accounting 2006, click Start, point to All Programs, point to Microsoft Small Business Accounting, and then click Data Tools.

      • If you are using Accounting Professional or Accounting Express, click Start, point to All Programs, point to Microsoft Office, point to Microsoft Office Accounting 2007 Tools or to Microsoft Office Accounting 2008 Tools, and then click Data Tools.

   2. In the Small Business Accounting Data Tools or Microsoft Office Accounting Data Utilities dialog box, click the Advanced Tools tab.

   3. Click Attach.

   4. In the Attach a Database dialog box, click Browse, locate the company database file that you want to attach, and then click Open.
      
      Notes

      • By default, the data file is located in the following directories:

        • In Small Business Accounting 2006, the data file is located in the following directory:
          C:\Program Files\MSSQL$MICROSOFTSMLBIZ\Data

        • In Accounting Professional and in Accounting Express, the data file is located in the following directory:
          C:\Program Files\Microsoft SQL Server\MSSQL. X \MSSQL\Data​​​​​

      • The company database file is an .sbd file.

   5. In the Database name field, type a name for the new company database (.sbc) file.

   6. Click Attach.

   7. Click OK.

   8. Click Close to close the Small Business Accounting Data Tools or Microsoft Office Accounting Data Utilities dialog box.