MSQUERY: "Can't Access" Adding Table Using UNC Network Drive

Last reviewed: September 13, 1996
Article ID: Q132481
The information in this article applies to:
  • Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, when you add a table that is located on a network drive, you may receive the following error message

   Can't access table <drive>:\<folder>\<table>

where <drive>:\<folder> is the default drive and folder for the data source that you are using (for example, C:\Program Files\Common Files\Microsoft Shared\MSquery), and <table> is the table that you added from the network drive.

CAUSE

This problem occurs when you add a table using a Universal Naming Convention (UNC) drive connection in the Add Tables dialog box. For example, if you enter the following in the Add Tables dialog box

   \\computer1\share

when you click Add, the network share is connected as expected, and the folders on this share appear in the Directories list in the Add Tables dialog box. However, when you click a table in the Table Name list, and click Add, you receive the error message indicating that Microsoft Query cannot find the table. Additionally, the error message indicates that Microsoft Query is looking for the table in the default directory for the data source instead of on the network drive.

This behavior occurs with data sources that use paths, such as a dBASE data source.

Note that this behavior does not occur if you enter the entire path to the table file in the Table Name box. For example, if you enter the following path in the Table Name box

   \\computer1\share\files\customer.dbf

the table is added as expected.

WORKAROUND

To work around this behavior, make a real network connection to the network drive that contains the table file that you want to add. To do this, use the following procedure:

  1. In the Add Tables dialog box, click the Network button.

  2. In the Path box, enter the UNC network name, such as "\\computer1\share" (without the quotation marks).

  3. Select or clear the Reconnect At Logon check box depending on whether or not you want to automatically connect to this share each time you log on to the network. Click OK.

  4. In the Drives list in the Add Tables dialog box, click the share you connected in Step 3 above.

  5. In the Directories list, select the folder that contains the table that you want to add.

  6. In the Table Name list, click the table you want to add, and then click Add.

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.


KBCategory: kbtool kbnetwork
KBSubcategory: xlwin xlquery

Additional reference words: 2.00 7.00 xl7



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 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.