Oracle ODBC Issue

  • Thread starter Thread starter Ed Lugo
  • Start date Start date
E

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)
 
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
 
I'd have serious concerns about the design of any database having over 400
columns, even an Oracle database.
Click to expand...


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