Microsoft KB Archive/149999

= "Data Truncated" Error If Path Contains Over 65 Characters =

Article ID: 149999

Article Last Modified on 8/17/2005

-

APPLIES TO


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

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.