How can I write my query, so that it will search through all of the .mdb files in one diretory?
So far, I have:
SELECT JOB.JobName AS JobName
FROM [;database=\\Maple\*.mdb].JOB
Maple is the server name, and I want to connect to all .mdb files in the root of Maple, then search through them...