ODBC not Displaying all Table Fields

vmtaylor

We have a (very badly designed) Navision 3.6 system running currently on the native database.
I am trying to link a table to MS Access but the table contains about 280 fields (I told you it was badly designed!) and C/ODBC seems to only allow 255 fields.

Anyone know of a way around this? Apart from redesigning the system!

Mauddib

Id recommend redesigning the system

However one way would be to link to the table and then design quieries on the table to display the fields you want. I presume you wouldnt want all 280 fields at once time. So just display the 30/40/150/etc you want at a time.

Might be worth checking if you can display more fields on the query than you can just by running the table.

dpardom

the problem is that nodb can just return fields from 1 to 255, so, to make a query of just one field, if the field is in the position 256 or higher, won't work.

Savatage

are you actually using all 280 fields?

I bet some of those fields already exist in other tables :-k
maybe you can outstream just the fields you need?????