SBFM2000: Remap Data Error "Unable to Open <Company Name>" (234129)

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\company name".

Where company name 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.