oracle fields exceed 255

[Les]

I am linking Access 2003 to oracle, however, one important table in oracle
has over 255 fields. The fields I need are being truncated off the 2003
linked table. Any suggestions on how to handle this? I do not have sufficient
priveledges to redifine the oracle database.

 

[Jeff Boyce]

Les

One approach might be to get several 'views' created in Oracle, then link to
those views instead of directly to the table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Les]

Thanks for your quick response Jeff, I will see if I can get the IT dept to
make those "views" for me and give it a try.

 

[GBA]

idle curiosity; even though a direct look at the linked table is truncated -
have you attempted to design a query using that table ??

I just wonder if in query design mode if whether or not you can see those
fields even though they are not viewable when looking at it as a table.
Because the query doesn't have the same width restrictions that the table
mode would have.....