Queries against large attached tables DB2 backend ODBC

[jeep2001]

First off I use pass-thru queries whever I can. However,
there are times when I am asked to run a query for our managing director at a whim and he needs the info quickly...therefore I use the QBE form. Most times the query takes up the whole machine..I can't alt-tab to anything else except Outlook. WILL A DUAL-CORE PROCESSOR LET ME OPEN ANOTHER ACCESS APP AND LET ME BE PRODUCTIVE..
SOME QUERIES THAT WE RUN AGAINST A DB2 BACKEND CAN TAKE OVER 1 HOUR....

 

[dhookom]

If all of the tables being queried are in DB2, then consider writing code to build your SQL and apply it to the SQL property of a saved pass-through query.

I don't know if any processor will save much time or allow you to run other processes.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]