MS Query problem
 

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


-----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
uninstalling/reinstalling Office
(including deleting the Office folder), plus recreating
the ODBC connection.

We have several other machines with similar configuration
and we are able to
do this with very quick response times.

Any ideas what might be causing this?
.