Open Query from another database

[thestappa]

Hello,



I am using 2007. I am currently using the following to access data from a separate database for a variety of functions.

    Dim DB As DAO.Database
    Set DB = OpenDatabase(GET_DBLINK("dbnamehere"))

Then I can use something like

Set rs = DB.OpenRecordset("select * from whatever")

to user to display data in on a form.



However, I am running into trouble when trying to open a query for viewing. I have a simple select statement to run against a table from by DB database. I want to mimic DoCmd.openquery "QUERY" but I don't know how to tell access to use the DB database when doing so.

[NTC]

an advanced topic, yet you list yourself as novice - - and so I will ask the basic question as to why is one even taking this approach. The vanilla method is to make links to the tables of that other DB - enabling you to easily make querieis without all this complexity.

[thestappa]

an advanced topic, yet you list yourself as novice - - and so I will ask the basic question as to why is one even taking this approach. The vanilla method is to make links to the tables of that other DB - enabling you to easily make querieis without all this complexity.

Maybe I'm just too modest...

Or maybe I should update my profile. I started building some forms/reports pulling data from a separate db. I was getting fancy with the vba and was going to try to just do the whole thing that way.

I did start importing objects and linking to tables so I'll probably just stick to that.