If I use DAO to update the Connect setting for a QueryDef for a SQL
Passthrough query, what do I need to do to ensure that the new connect string
is used and available in the code that follows?

Currently, the only way that I can get this change to "stick" is to either
manually change the setting or close/re-open Access. As I have thousands of
external databases to attach to (the same tasks are performed on each of
these), neither of these is an option. If I use QueryDefs.Refresh or
something similar, it doesn't seem to make any difference - the change is not
in effect (even though, looking at the properties of the query, the change is
there)

Any suggestions?

"ATD" wrote:

> If I use DAO to update the Connect setting for a QueryDef for a SQL
> Passthrough query, what do I need to do to ensure that the new connect string
> is used and available in the code that follows?
>
> Currently, the only way that I can get this change to "stick" is to either
> manually change the setting or close/re-open Access. As I have thousands of
> external databases to attach to (the same tasks are performed on each of
> these), neither of these is an option. If I use QueryDefs.Refresh or
> something similar, it doesn't seem to make any difference - the change is not
> in effect (even though, looking at the properties of the query, the change is
> there)
>
> Any suggestions?