How to find a query source
 

I have a query to an external database but when I run the query it brings up
some anomalies. When I check the data in the database these anomalies do not
exist. I am suspecting therefore that the query is pointing to another
database, probably a backup. How can I find out what the source of the query
is? TIA
--
Tony

How to find a query source
 

with thisworksheet.querytables(1)
debug.print connection
debug.print sql
end with

HTH
--
AP

"TonyL" a écrit dans le message de
...
I have a query to an external database but when I run the query it brings
up
some anomalies. When I check the data in the database these anomalies do
not
exist. I am suspecting therefore that the query is pointing to another
database, probably a backup. How can I find out what the source of the
query
is? TIA
--
Tony