In a previous tip, we talked about getting data from two separate data connections and how it wasn't possible to run a query against both. The only way to do this would be to link one database to another within the database itself.
While this won't solve this problem, Walter Walker suggested that if you create a manual recordset (see previous tips for the instructions) you could add data from one database and the other, and then use the sorting and filtering capabilities of the recordset to manipulate the data. Thanks for the tip, Walter.