I have two Access databases.



One holds tables of source information that must be updated and uploaded 

at least weekly by the site manager.



The other holds tables of dynamic data that change frequently in response 

to site visitor activity, and must not be over-written when the source 

information is re-uploaded.  This database also contains links to the 

tables from the first database.



Creating a Query that retrieves data spanning tables from both databases 

works fine when the Query is executed from inside Access.



BUT - attempting to access that Query from ADO in ASP always fails,  

unable to access the database that is not the connection object for the 

query, even though this was the 'open' database in the Access testing.



The failure actually comes out as a permission error,  but it isn't a real 

permission error because accessing the same data in a direct query to the 

second database works fine.



I have a really NAFF emergency workaround that queries one database and 

then loops, querying the second for all records found in the first.  But I 

worry about elegance (and performance), and I'd like something better for 

the longer term...



Any suggestions gratefully received



## dave ##