Field limit and linked tables
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)