# Microsoft Knowledge Base

## Data Source Uses Active Folder Instead of Database Directory

Last reviewed: September 12, 1996 Article ID: Q124754
The information in this article applies to:

- Microsoft Query for the Macintosh, version 1.0

## SYMPTOMS

In Microsoft Query, when you use a Microsoft FoxPro or dBASE data source to add a table to a query, the directory that appears in the Add Tables dialog box may be the active folder instead of the folder that you specified in the Database Directory box when you set up the data source.

## CAUSE

This behavior occurs if you are using Apple System version 7.5.

When you configure a data source using the ODBC Setup Control Panel, you can specify a directory that contains your database files by adding the path to the Database Directory box. Normally, the folder that you enter in this box appears in the Add Tables dialog box when you use the data source in Microsoft Query. However, if you are running Apple System version 7.5, the Database Directory is ignored, and the current working directory is always selected in the Add Tables dialog box when you use the data source to add a table to your query.

Note that if you leave the Database Directory box empty, then the current working directory is used when you use this data source, even if you are using a version of Apple System software other than 7.5.

## WORKAROUNDS

To work around this behavior, use either of the following methods.

Method 1: select the folder that contains your database files in the Add

              Tables dialog box. Note that when you select a folder in the Add
              Tables dialog box or the Open Query dialog box, this becomes the
              default working directory for that session of Microsoft Query.

Method 2: In the General controls control panel, under Documents, select

              the Folder Which Contains The Application option.

Method 3: Install Apple System 7.5.3.

## STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

## REFERENCES

For more information about Configuring Data Sources, choose the Search button in Q+E ODBC FoxPro Driver Help and type:

       configuring data sources

> KBCategory: kbtool
> KBSubcategory: xlmac xlquery

> Additional reference words: 1.00 5.00

> THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.