oracle fields exceed 255

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

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
 
L

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top