Workaround til at linke mere end 255 felter via ODBC

If they arent all used then make a view

dont know what dB your linking to but if your using SQL server you can make a view on the server and link this into your Access dB

Hi Terry

I need to link to AS400 .... is it possible to make a view there ?

Well I dont know much at all about AS400 but I would think it possible to make a view. Wouldnt the administrator be able to help you there?

hope you could use the answer.

tak

I haven´t found a solution that is acceptable :-( ... but I´m still working ...

Læs http://www.eksperten.dk/spm/807231 - Jeg går ikke udfra, at du skal bruge samtlige >255 felter på én gang.. Du kan med fordele bruge MS Query til, at udvælge de kolonner du skal bruge fra AS/400 i MS Query.. Og bruge en SQL Pass-Through Query i Access efterfølgende til, at hente data..

Har det løst dette problem (http://www.eksperten.dk/spm/807231 )?