I need to transfer queries from DB1 to DB2 by DB3. ie the code to transfer the queries from DB1 to DB2 will be in DB3 that has nothing but the code to transfer. currently ive tried both the transferdatabase method and the copyobject method, the problem is both methods only allow you to transfer from the DB your running the code from (DB3), which will not contain the tables required for the queries, which causes the queries to break during the transfer process. id realy like to run the code from a seperate DB3 and transfer from DB1 to DB2 or find a way to import from DB1 to DB3 then export from DB3 to DB2 ie using the transferdatabase method without breaking the queries. any help would be appreciated.

try to transfer text and not queries.

strQueryInText = db1.querydefs("qryTotals").sql

and them create the query in the other database db2.

try to transfer text and not queries.

strQueryInText = db1.querydefs("qryTotals").sql

and them create the query in the other database db2.

worked great thanks