Scenario:
I have an oracle table that has about 400 fields in it. I only need the information in about 5 of the fields.

However, if I set up the table as a linked ODBC table in access, it only shows me the first 255 fields, in *alphabetical order.* I know that access 2002 has a field limit of 255, but is there a way to change *which* fields Access 2002 pulls from the odbc link? One of the 5 fields I need is alphabetically after the first 255. (starts with a v)

Thanks
1

In Oracle create a view of which fields you need, then link to that view.

Regards,

Beth M

I'd already thought of that, but it will take about 3 weeks of paperwork/approval before they'd be willing to add the view. (corporate processes are a pain) Right now, I'm stuck with the existing tables/views.

Thanks

What about ADO and only go after the fields you need, and forget linking through ODBC?
Beth M

I think Beth could be onto something here -
If you can query the database, rather than link to it, you might be able to get around the problem.

Steven

I am a loud man with a very large hat. This means I am in charge