Creating a main interface for control of multiple databases?

[Stadler09]

Hello,
I have three databases that are currently working "together". Example: One database has tables that are used as a basis to summarize data in another database. Tables between the databases are linked. The three databases have sets of queries that must be run in a specific sequence. It would be great if I could have one main menu with command buttons to activate queries in each individual database so the end user does not get confused as to the sequence in which the queries must be run. Any ideas on how to do this? Perhaps some java code could be used to create the GUI? I don't really know. Any ideas? Thanks!
Craig.

 

[bustersports]

Craig,
Have you tried putting the sequence in code so that the user only has to select the button and the sequence will run correctly? If the sequence varies, you could also write some If,then,else statements to account for this.
EX: If the user click a Yes/No field for sequence 1 to run, you could have the code look to see if this field is -1 (Yes), then run the order you want, else run a different query order based on being a 0 (No).

 

[Stadler09]

Ideally, I would like to put the sequence in code, but I would like to break it up into logical steps. Some of the queries are fairly complex and are hitting huge tables....so some queries take 5 or 6 hours to run. My main problem is that I don't know how to write the code to run a query that resides in another database.