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 <path> <filename.mdb>... the database is in use. Close
all reports, and start again.
where <path> is the location of
your SBFM accounting database and <filename.mdb> 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:
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