How to call a query located in another database?

[jsteven]

I have two databases. The first has the data and the query. The second needs the results of the query. I want to call the query from the second database. How do I call the query in the first database from the second database? Note: I tried copying the query to the second database and make links to the tables, but I am not getting the right results with the copy of the query.

 

[DougP]

you can Import the query in your database from the other database.<br>Or you can Link the Tables in the other database to your database then import the query. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[jsteven]

Thanks for your response. I have tried that, but I don't get the right numbers. Is there a way to call or execute a query that is in another database?

 

[JimHorton]

You can use OpenDatabase, then refer to that db's querydefs collection:<br>Dim DBREM As Database, QD As QueryDef<br>Set DBREM = DBEngine(0).OpenDatabase(&quot;C:\Infoware\CFAC\cfac97.mdb&quot<br>Set QD = DBREM.QueryDefs(&quot;QUERY1&quot<br>QD.Execute<br>--Jim