Knowledge Base

"Data Truncated" Error If Path Contains Over 65 Characters

Article ID: 149999

Article Last Modified on 8/17/2005

Microsoft Excel 95 Standard Edition
Microsoft Query 2000

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:

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: KB149999