Microsoft KB Archive/114840

= ACC: ORACLE Driver Errors on Delimited Column Names =

Article ID: 114840

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q114840





SYMPTOMS
This information is extracted from an article in the LANPROD knowledge base. To find the most current information, see the "References" section later in this article.

The ORACLE ODBC Driver gives an error on any SELECT statement that contains an outer join (in the ODBC escape-clause syntax) on a delimited column name that is greater than 17 characters. As a result, when you are using Microsoft Access or Microsoft Visual Basic to connect to an ORACLE server, you cannot perform outer joins on columns whose names are longer than 17 characters.



RESOLUTION
Rename the joined columns on the server so that each column has less than 17 characters, then re-attach the tables.

