Symptoms
When you try to restore a backup or try to burn a backup to a CD-RW or to a DVD-RW in Microsoft Office Accounting Professional or in Microsoft Office Accounting Express, you receive one of the following error messages.
Error message 1
Handle does not support synchronous operating, the parameters to the file screen constructor may need to be changed to indicate the handle was opened asynchronously (That is, it was opened explicitly for overlapped IO)
Error message 2
The media family on device C is incorrectly formed. SQL server cannot process this media family. RESTORE HEADERONLY is terminating abnormally.
Error message 3
Access is Denied.
Cause
This problem occurs for one of the following reasons:
-
If you receive Error message 1, you do not have a Microsoft SQL Server product installed on the computer. See Method 1 or Method 2 in the "Resolution" section.
-
If you receive Error message 2, Microsoft SQL Server 2005 is installed on the computer. You are trying to restore the backup by using a backup file on a portable storage device. However, the portable storage device is incompatible with the SQL Server 2005 restore process. See Method 3 in the "Resolution" section.
-
If you receive Error message 3, you may be trying to burn the backup to a rewriteable CD (CD-RW) or a rewriteable DVD (DVD-RW). The backup that is directly written onto the media conflicts with the burning process. See Method 4 in the "Resolution" section.
Resolution
To resolve this problem, use the appropriate method.
Method 1
Manually remove Accounting Professional or Accounting Express. Then, reinstall Accounting Professional or Accounting Express.
For more information about how to manually remove Accounting Professional or Accounting Express, click the following article numbers to view the articles in the Microsoft Knowledge Base:
945462 How to manually remove Accounting Professional 2008 or Accounting Express 2008 and SQL Server 2005
930294 How to manually remove Microsoft Office Accounting 2007 and Microsoft SQL Server Express 2005
Note Microsoft SQL Server 2005 Express Edition is installed when you reinstall Accounting Professional or Accounting Express.
Method 2
Install SQL Server 2005 Express Edition. For information about how to obtain SQL Server 2005 Express Edition, visit the following Microsoft Web site:
Method 3
Copy the backup file from the portable storage device to a local hard disk drive. Then, use this backup file to restore the backup on the computer. To do this, follow these steps:
-
Click Start, and then click My Computer.
-
Connect the portable storage device that contains the backup file to the computer.
-
Double-click the name of the portable storage device.
-
Right-click the backup file, and then click Copy.
-
Double-click a local hard disk drive. For example, double-click Local Disk (C).
-
On the Edit menu, click Paste.
-
Start Accounting Professional or Accounting Express.
-
Use the backup file that you copied to the local hard disk drive to restore the backup on the computer.
Method 4
Create a backup file for your company, and then copy the backup file to the CD-RW or to the DVD-RW. To do this, follow these steps:
-
Start Accounting Professional or Accounting Express.
-
On the File menu, click Open company to open your company.
-
On the File menu, point to Utilities, and then click Data Utilities.
-
On the Basic Tools tab, click Backup.
-
Click Browse, specify a file name for the backup file, and then click Save.
Note By default, the location for backup files is as follows:C:\Documents and Settings\User_name\My Documents\Small Business Accounting\Backups
-
If you want to add a password to protect your backup file, type the password and the verification password.
-
Click OK.
-
After the backup is complete,click Close in the Microsoft Office Accounting Data Utilities File dialog box.
-
Close Accounting Professional or Accounting Express.
-
Click Start, and then click My Computer.
-
Locate the backup file that you saved in step 5.
-
Right-click the backup file, and then click Copy.
-
Locate the writable CD or DVD drive, right-click the drive, and then click Paste.
