Pass-Trough query by VBA procedure

[inoxo]

Hi,

I would like to write a vba procedure to query a table with passtrough.

I need to use a passthrough query because the table I use is too wide to be queried normally in Access. It's a DB2 table which counts more than 256 column.

Using Access query interface to query the table works fine.
But I would like to automate it with embedded SQL (no stored queries) into a button triggered procedure.

Thanks for help.

 

[Bungle]

See the principle of how to do this halfway down this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=134597