Code to launch a query for Access DB (not the one code running from)

[ChrisOjeda]

I want to launch an Access DB query but the query resides in a different Access DB than the one I am running my code from? Any ideas? Chris

 

[TonyJollans]

Hi Chris,

To the best of my knowledge you need to use a separate workspace for each database you are using. I posted some code for this in thread702-558955 which should get you started.

Enjoy,
Tony

 

[ChrisOjeda]

Tony,

I tried using your commands but it won't compile. I have Access 2000.

Turns out I only need to run a macro... can anyone help?

 

[ChrisOjeda]

???

 

[TonyJollans]

Sorry, Chris,

What problem do you have compiling? Are you missing a reference to DAO? I have Access 2K as well and it works for me.

Tony

 

[ChrisOjeda]

TJ,

Thanks for the follow up. This compiles below but I get an error message that Macro temp can not be found. That means it is trying to run the macro out of the database I am running the code from and NOT the other database. I am sure that your workspace and database parts work perfect. I just need to now run that macro. Any more ideas? Thanks for all the help so far... Chris

Private Sub cmdUpdate()
Dim wksWorkspace As DAO.Workspace
Dim dbDatabase As DAO.Database

Set wksWorkspace = CreateWorkspace("Chris", "admin", "&quot
Set dbDatabase = wksWorkspace.OpenDatabase("T:\Default_Project\FC_Impact_Analysis\FC_Impact_Analysis.mdb&quot

DoCmd.RunMacro "temp"

dbDatabase.Close
wksWorkspace.Close

Set dbDatabase = Nothing
Set wksWorkspace = Nothing

End Sub

 

[TonyJollans]

Hi Chris,

I'm afraid, for the second time this evening, I have to say I don't know. I've just had a look at the help and DoCmd.RunMacro only runs a macro in the current database and there is no indication of how to run one in another database, and everything I've tried has failed. Can you run your query without the macro?

Maybe someone else out there knows how or can confirm it's not possible.

Sorry not to be more help.

Enjoy,
Tony

 

[ChrisOjeda]

Tony,

No problem... you were a big help... I am all the more closer. I can run the three queries instead of the macro. However, is there special coding to do this for a remote database???