Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/169886

From BetaArchive Wiki
Knowledge Base


SBFM97: Error Updating Database After Creating Report

Article ID: 169886

Article Last Modified on 11/17/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q169886

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.

where <path> is the location of the Small Business Financial Manager accounting database and <filename.mdb> is the accounting database that is created by the Small Business Financial Manager.

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.


Additional query words: XL97

Keywords: kberrmsg kbprb KB169886