oracle fields exceed 255

  • Thread starter Thread starter Les
  • Start date Start date
L

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