MSQuery: "Data Truncated" Error If Path Contains Over 65 Characters

ID: Q149999

The information in this article applies to:

Microsoft Query for Windows 95, version 2.0
Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Query version 2.0, when you attempt to use an ODBC data source, you may receive the following error message:

Data truncated

If you click OK to continue, you can still proceed and use the data source.

CAUSE

This problem may occur if the path defined by the data source is longer than 65 characters. For example, the following path may result in an error message because it is 67 characters in length:


   c:\apps\msoffice\excel\subdir01\subdir02\subdir03\subdir04\subdir05

This error only occurs when you use the following ODBC 3.0 drivers:


   Microsoft dBASE Driver
   Microsoft FoxPro Driver
   Microsoft Excel Driver
   Microsoft Text Driver
   Microsoft Paradox Driver

WORKAROUND

To work around this problem, either shorten the path name in which the data resides, or move the database file or files to a path containing fewer characters.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Query version 2.0 for Windows 95.

Additional query words: directory folder ODBC 3.00 66 msquery


Keywords          : xlquery 
Version           : WINDOWS:2.0,7.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: June 23, 1999