MS Query problem

G

GJones

Hi Mike;

I do not have an answer for you on the multiple
instanciations of MS Query, but, one work around might be
this.

Instead of using MS Query us a macro to establish the
connection via a DSN and then execute a string query
against the AS/400. This would reduce your overhead and
excelude MS Query all together.

I would suggest using ADO as the connection method.

Probably not exactly what you are looking for but it would
speed all computers up and reduce the overhead.

Thanks,

Greg
[email protected]
-----Original Message-----
I'm trying to use MS Query to get data from an AS/400 via an ODBC connection
in Excel 2002.

When the "New Database Query" wizard starts, the signon is extremely slow.
When we look at the Task Manager (Windows XP), the applications tab show 2 MS
Query applications running; 1 associates to MSQRY32.exe, the other to
Explorer.exe, and both show not responding. Eventually the query runs, but
after 5+ minutes. We've attempted
Click to expand...
uninstalling/reinstalling Office
 
Top