"Philip Herlihy" wrote:

> phillbee wrote:
> > 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
>

"Philip Herlihy" wrote:

> phillbee wrote:
> > 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
>