Oracle ODBC Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Lugo - 29 Jun 2004 03:56 GMT

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 elugo1@exchange.ml.com

Reply to this Message

Graham R Seach - 29 Jun 2004 05:32 GMT

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 hope someone can help! I am trying to connect to a table
> within an Oracle Databse. I am able to connect to the
[quoted text clipped - 13 lines]
> Any help would be much appreicated! Please post back or
> email me at elugo1@exchange.ml.com

Reply to this Message

Lynn Trapp - 29 Jun 2004 15:01 GMT

> 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.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Reply to this Message

Graham R Seach - 29 Jun 2004 23:57 GMT

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

> > 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.

Reply to this Message

Lynn Trapp - 30 Jun 2004 04:40 GMT

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

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdeisgns.com/Security.htm

> Lyn,
>
[quoted text clipped - 16 lines]
> > You and me both. I've seen some pretty wide Oracle tables, but never one
> > that approached 400 fields.

Reply to this Message