Querying DB2 thru Access

[MacroAlan]

My client has an ODBC connection to a store of DB2 data. Even the simplest query seems to take forever going thru Access Query Designer.

I have a contact on the DB2 side that has talked about adding indexes to his data. I am afraid that that might not be enough.

Got any suggestions for better tools to run queries? I thought about running a query at the beginning to get temp tables and then run everything else from that.

Whatever I come up with has to be taught to non-techies.

Alan

It is easier to apologize than ask permission!

 

[AlexCuse]

Pass-through queries might be an option for you? I don't use them too often, but I know you can use ADO connections which should be faster than ODBC.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[PHV]

Even the simplest query seems to take forever
Even passthru queries ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MacroAlan]

I need to try pass-through queries. More research is in my future!

Alan

It is easier to apologize than ask permission!

 

[AlexCuse]

>>> More research is in my future!

Probably in all our futures. It never stops, does it?

Post back if you run into any issues

Ignorance of certain subjects is a great part of wisdom