Microsoft KB Archive/234129

= SBFM2000: Remap Data Error "Unable to Open " =

Article ID: 234129

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Business Solutions Small Business Manager 7.5, when used with:
 * Microsoft Office 2000 Small Business Tools

-



This article was previously published under Q234129



SYMPTOMS
When you try to map accounts to different categories using the Remap Data command in the Microsoft Small Business Financial Manager (SBFM), an error message similar to the following appears:

Unable to open "C:\Windows\All Users\Application Data\SBT\Databases\ ".

Where  is the name of your QuickBooks accounting company file.



CAUSE
This problem occurs when you do the following:
 * You import data into the SBFM from Inuit QuickBooks for Windows.

-and-
 * Your company name in QuickBooks ends with a period character (.).

-and-
 * You click Remap Data on the Financial Manager menu and then try to map accounts to different categories.



WORKAROUND
To work around this problem, after you import your QuickBooks accounting data, rename the accounting file that the SBFM creates so that it does not include the period character. By default, your accounting data file, a Microsoft Access .mdb file, is located in the following folder:

C:\Windows\All Users\Application Data\SBT\Databases

Use Windows Explorer to rename your accounting file to exclude the ending period character. For example, if your file is named "My Company, Inc..mdb" change the name to "My Company, Inc.mdb" (without the quotation marks).



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: XL2000 OFF2000 SBFM2000

Keywords: kbbug kbsbt kbpending KB234129

-

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

© Microsoft Corporation. All rights reserved.