Hello,

I have an MS Query that will hang reading data after
performing the following steps 2 times:

1. Changed the CommandText statement to retrieve new data
2. Called the Refresh Method

Sometimes the data will read if I wait for a few minutes,
but other times Excel seems to have locked up entirely.
This only happens after I have performed the above steps
twice. However, if I close the workbook (the query has
been saved and is being reused), the query works when I
reopen it.

I have tried different data sources (created a new Access
DB and used that), but it still gives the same results.
The only thing I have noticed is that their is a join in
the query. If I am querying from only 1 table, then
there isn't any problem.

Is there some way to reset the connection/recordset or
whatever it is that Excel does when it closes the file?

Thanks,

Malcolm