The only way that I have found to link to a Query in another Access database is using a Query and Changing the path to the database as shown in the following photos. Check out an article that I wrote on Remote Queries a while back
I have been programming and supporting Microsoft Access databases since 1995. In 2007 I received the Access MVP award from Microsoft because I waste too much time writing newsletters and blogs. Why not sign up for one of my newsletters at http://www.vb123.com.au and look for newsletter on the left.