A
ATD
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?
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?