Union Query Across Databases

[jo15765]

How do you run a Union Query when the 2 query's you want to union are in separate databases?

[JoeM]

I would probably link the other table(s) that the query uses to the other database, and recreate the query there based on those linked tables (so they all exist in the same database), but it looks like you might be able to actually link the query to the other database.
See: http://stackoverflow.com/questions/1...ccess-database