I was hoping that Microsoft Access 2002 would allow users to see all
the columns of an Oracle database table that contained more than 255
columns. I noticed that my Oracle8 ODBC driver is only at 8.1.6.0.0
for win95, win98 and winNT. If I upgraded my ODBC driver would Access
be able to recognize the columns beyond the 255th column? or is this
an Access limitation?
Please don't lecture me about good table design and recommend
splitting the table up into smaller table(s) because that is not an
option for me at this point.
If 255 columns is an Access limitation and there is no way around it,
I'm thinking about creating a database view to virtually split the
table so that the new columns beyond the 255th column appear to be in
a different table and perhaps Access would recognize these columns.
Has anybody tried this?