Linking to selected fields in an external table

[phillbee]

I want to make an external link to a table on an Oracle database using an
ODBC connection. Unfortunately the table in the Oracle database has
approximately 300 fields and only the first 255 appear in Access, which I
believe is the limit. However, I don't need all of the fields to be linked.
Can anyone tell me if there is a way to selectively link to the fields I
require, hence keeping the number of fields below 255?

 

[Philip Herlihy]

I want to make an external link to a table on an Oracle database using an
ODBC connection. Unfortunately the table in the Oracle database has
approximately 300 fields and only the first 255 appear in Access, which I
believe is the limit. However, I don't need all of the fields to be linked.
Can anyone tell me if there is a way to selectively link to the fields I
require, hence keeping the number of fields below 255?

I understand Oracle provides "Views" (essentially a publicly visible
query) to which you can link from Access. I'd suggest you ask the
Oracle DBA to provide one to suit you, and link to that.

HTH

Phil, London

 

[phillbee]

Thanks for the suggestion. I have discussed this with our Oracle DBA and in
fact there are Views set up. Unfortunately these are not displayed through
the ODBC link to Access. If you have any suggestions as to how to make them
visible so that I could link to a suitable Vies that would be a great help.

 

[Philip Herlihy]

Thanks for the suggestion. I have discussed this with our Oracle DBA and in
fact there are Views set up. Unfortunately these are not displayed through
the ODBC link to Access. If you have any suggestions as to how to make them
visible so that I could link to a suitable Vies that would be a great help.

'Fraid you'd need an Oracle person for that! I'd guess it's just a
matter of creating a tailored view and then configuring it to be visible
externally, but it's 19 years since I last touched (superficially)
Oracle...

Phil

 

[phillbee]

Thanks for you help; I'll wait and see if anyone else can help on the Oracle
side.