SBFM97: Error Updating Database After Creating Report

• Microsoft Excel 97 for Windows
• Microsoft Small Business Financial Manager 97 for Microsoft Excel 97

SYMPTOMS

When you update accounting data in the Microsoft Small Business Financial Manager 97 for Microsoft Excel 97, the following error message appears

   Unable to update the database in <path> <filename.mdb>... the
   database may be in use. Please close any workbooks, etc. which
   have the database open.

CAUSE

The problem occurs when the following conditions are true:

• You import accounting data from Intuit Quickbooks, create a financial report, and then save and close the overview.

      -and-
  

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

WORKAROUND

To workaround this problem, close all open workbooks and quit Microsoft Excel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.