MAximum Number of Fields in a linked table

  • Thread starter Thread starter Tom Coffinger
  • Start date Start date
T

Tom Coffinger

I have an app which is dumping data into a sql table it creates. It dumps
about 400 fields into the sql table. The sql table creates correctly,
however when I link to it from Access2k3 using ODBC and the SQL Driver, I am
missing the last 100 or so fields. It appears to me like there may be a max
of 256 fields that can be pulled with the link. Is this correct? Is there
anyway around this?? And, no, unfortunately, having a table with fewer
fields is not an option. I am VERY limited on what can be done with the
originating app.

TIA

Tom
 
Access doesn't support more than 255 fields. You could try a series of
queries, each with 255 or fewer fields, all based on the same table.
 
Doug,

Yeah, I can handle accessing the data, etc in Access. I really was just
more curious if it was a limitation of ODBC or Access it's self.

Bottom line is the APP that is generating this is a P.O.S. (and no that does
not mean Point of Sale), but is beyond my control. Thanks for the info.

Tom
 
Back
Top