Run a query on another Db 1

[cretanion]

Is it possible to put in a Form, some sort of link or code to run a query in another database. The query in the other database is a make-table query.

docmd.OpenQuery ???

 

[randy700]

I don't think you can access the query in the other database, but you can link to the tables. Why not just copy the query into your db, link to the tables in the other db, and run the query in that manner?


Randy

 

[PWise]

one way

Dim appAccess As New Access.Application
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase ("\\server\data\filename.mdb")
appAccess.DoCmd.OpenQuery "queryname"