"Data Truncated" Error If Path Contains Over 65 Characters (149999)

The information in this article applies to:

Microsoft Excel for Windows 95
Microsoft Query

This article was previously published under Q149999

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.

Modification Type:	Minor	Last Reviewed:	8/17/2005
Keywords:	KB149999