Running a Query from a separate Database

[CoffeeNow]

I would like to run a maketable query on a separate database by clicking a button on the current database. Is this possible, and if so, how?

Three points to make:
1) the separate database in which I want to run the maketable query is password protected.
2) I know the password
3)Access97

 

[RickSpr]

Assuming that the source data for the MakeTable query is also in the other database, here's what you do:

    Dim ws As Workspace, db As Database

    Set ws = DBEngine.CreateWorkspace("Temp", User, Password)
    Set db = ws.OpenDatabase(PathName)
    db.QueryDefs(MakeTableQueryName).Execute
    Set db = Nothing
    Set ws = Nothing

Rick Sprague