MSAccess has a limit of 255 columns on any queries that are run locally with the MSJet engine, and the 255 limit also impacts the list of fields that MSAccess pulls from the database and presents to you in the drop-down menu of field names (i.e., Access only shows you the first 255 fields).
In the old Oracle9i driver, I could code a "pass-thru" SQL query that would send the SQL string directly to the Oracle server and run it at the server (instead of running it locally in MSJet engine). I could include any fieldname in this pass-thru query string and Oracle would return the data to me, thereby working-around the 255 field limit in Access (plus the server-side queries are much faster since Oracle does all the lifting server-side and just returns the results via XML stream to the client)
However, with the new RDA ODBC driver, the 255 field limit is impacting me. I tried a pass-thru SQL query, but RDA handles the pass-thru queries differently and any field I specify in the SQL string which is not listed in the MSAccess drop-down is giving error of "could not find any column information for table:Administrator_CUSTOMERS". I know I spelled the column name correctly because I looked in the OA_COLUMNS system table to make sure I got the spelling correct with the underscore replacement of special chars.
Has anyone run into this quirk and do you have any creative solutions?