Linked SQL table

[Guest]

Access 2003 11.6566.8122 sp2

I have linked to a SQL table using an ODBC connection. The table I am
linked to has 467 fields. When I view the table through access I can not see
all of the fields. Is there a setting I can change that will allow me to see
all 467 fields?

 

[Douglas J. Steele]

Not as far as I'm aware. Access is only capable of handling 255 fields in a
table.

You might be able to use queries to look at 255 fields at a time (so two
separate queries).

 

[John W. Vinson]

Access 2003 11.6566.8122 sp2

I have linked to a SQL table using an ODBC connection. The table I am
linked to has 467 fields. When I view the table through access I can not see
all of the fields. Is there a setting I can change that will allow me to see
all 467 fields?

No.... Access is limited to an absurdly huge 255. I presume this is an
intentionally denormalized "data warehouse" table?

You may want to create updateable Views in SQL server of subsets of this
table, and link to those Views rather than directly to the table.

John W. Vinson [MVP]