XL: Certain ODBC Drivers Do Not Support Long File Names

 Last reviewed: June 3, 1997
Article ID: Q148149
7.00 97 WINDOWS kbusage kb3rdparty kbtool kberrmsg

The information in this article applies to:

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

SYMPTOMS

When you attempt to access a file saved in one of the following formats with either Microsoft Query or Data Access Objects (DAO), you receive an error message if the file name contains more than eight characters (not including the characters that comprise the file name extension): 

   dBASE
   FoxPro
   Paradox
   Text
In Microsoft Query, you may receive the following error message: 

   Invalid string or buffer length
When you use DAO in a Visual Basic for Applications macro, you may receive one of the following error messages:

Microsoft Excel 97

   Run-time error '3011':
   The Microsoft Jet database engine could not find the object 'my
   file'. Make sure the object exists and that you spell its name
   and the path name correctly.

Microsoft Excel 7.0

   Run-time error '3011':
   Couldn't find object '<my file>'
where the file being accessed is named "My File.dbf." The object name in the error message you receive may be different from the ones described above.

CAUSE

Versions of the dBASE software that are designed for MS-DOS-based systems and released prior to the release of the Windows 95 do not support long file names. The driver used by DAO and Microsoft Query is designed to be compatible with these versions of dBASE, and, therefore, doesn't support long file names.

MORE INFORMATION

The Microsoft ODBC drivers for dBASE-formatted files that are for use on the Macintosh platform do support long file names. However, it is still necessary for these names to remain compatible with MS-DOS based versions of dBASE software products. For this purpose, the driver mentioned in this article supports only file names that conform to the 8.3 MS-DOS file naming convention.

WORKAROUND

If you need to access dBase or Microsoft FoxPro files with long filenames through Microsoft Query of DAO, you can install the Microsoft Visual FoxPro ODBC driver.

The following file(s) are available for download from the Microsoft Software Library: 

 ~ Vfpodbc5.exe (size: 1619072 bytes)
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

KBCategory: kbusage kb3rdparty kbtool kberrmsg
KBSubcategory: xlquery xldao
Additional reference words: 7.00 8.00 97 LFN
Keywords : kbualink97 xldao xlquery kb3rdparty kberrmsg kbtool kbusage
Version : 7.00 97
Platform : WINDOWS

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: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.