Running a query from another database

[manicamaniac]

Hello,



I need to run an Append Query from another database, but I'm having problems with it..
Set db = OpenDatabase("T:\DATA\GPM\AccessDB\GPM_custom_rpts .mdb")
DoCmd.OpenQuery "qry_123", acNormal, acEdit

When I run this code, an error message is shown saying that could not run the specified query... Any possible solutions?


Thanks a lot!

[ExpertNovice]

From the OpenQuery Method documentation in Access 2003

 
        QueryName Required Variant. A string expression that's
        the valid name of a query in the current database

The issue:
Notice the OpenQuery command never references the "db" object set in the previous statement. (The space before .mdb is not hurting anything at this point.)


option 1:
Create a query in the current database similar to the following:

      SELECT * FROM qry_123 IN "T:\DATA\GPM\AccessDB\GPM_custom_rpts.mdb"

The set db command is not need. (If used for another purpose don't forget to "set db = nothing" when done.)


option 2:
This is very doubtful. However, if the executing database is running as an automation server you could execute a macro in GPM_custom_rpts and have the macro execute the query. Google AccessAutomation.