Oracle ODBC Issue

[Ed Lugo]

I hope someone can help! I am trying to connect to a table
within an Oracle Databse. I am able to connect to the
table however, the table has over 400 fields. When I link
to the table using the Oracle ODBC I get back only 258
fields. Has anyone ever run into this problem before?

It seems as there maybe some limitation to the number of
fields you can bring back when attaching a table using
ODBC.

Is there a setting I can change either on my MS Access
options or on the Oracle ODBC Machince source I have
created that would allow me to bring back more than 258
fields?

Any help would be much appreicated! Please post back or
email me at (e-mail address removed)

 

[Graham R Seach]

Ed,

The maximum specified number of fields per Access table or query is 255, and
I'm afraid there's nothing you can do about it.

There is no way you can use that many fields (columns) at one time anyway,
so it shouldn't present a problem. Just base your Access tables of Oracle
views that return *groups* of columns from that table.

I'd have serious concerns about the design of any database having over 400
columns, even an Oracle database.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Lynn Trapp]

I'd have serious concerns about the design of any database having over 400

columns, even an Oracle database.

Graham,
You and me both. I've seen some pretty wide Oracle tables, but never one
that approached 400 fields.

 

[Graham R Seach]

Lyn,

Oracle DBAs do tend to be a tad strange don't they! And they seem to love
multi-column date keys.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Lynn Trapp]

<VEG> Don't get me started on Oracle DBA's, but you are so right.