How to find a query source

T

TonyL

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
 
A

Ardus Petus

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

HTH
 
Top