Microsoft KB Archive/164747

= SBFM97: Error Updating Accounting Data =

Article ID: 164747

Article Last Modified on 8/5/2004

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q164747



SYMPTOMS
When you update accounting data in the Microsoft Small Business Financial Manager (SBFM) for Microsoft Excel, version 2.0, the following error message appears

Unable to update the database in ... the database is in use. Close all reports, and start again.

where is the location of your SBFM accounting database and  is the SBFM accounting database that is created by the SBFM.



CAUSE
The problem occurs when the following conditions are true:


 * You import an accounting dataset, click What-If Analysis, and then save and close the Overview. -and-


 * You attempt to update the accounting dataset by clicking Update in the "Import your Accounting Data" dialog box.



WORKAROUND
To work around this problem, do either of the following before you update the accounting data:
 * Close all open workbooks and quit Microsoft Excel. -or-


 * In the What-If Analysis workbook, use a function, such as Profitability, that recalculates the workbook.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in the updated versions of the Quickbooks driver and Msapp.dll.

The following file is available for download from the Microsoft Download Center:

Sbfm97qb.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Additional query words: XL97 sbfm 8.0 sbfm97qb exe

Keywords: KB164747

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.