Open another database and close the current one

[Guest]

Hi

I would like to finish a module by open another database (that I just copied
some tables and reports into) then closing the current database, leaving the
second (target) database open, mainly since I will need to run procedures
from the target database. Is this possible? Here is the logic flow:

Create new database (figured this section out)
Write table to new database
transfer Form to new database
transfer report to new database

open report in new database - (not figured this section out)
close current database
review report in new database
run module in new database
basically do things in new database

 

[John Nurick]

Hi Biggles,

Take a look at the TSI SOON utility at http://www.trigeminal.com/.

Please give my best to Algy.

 

[Guest]

Thanks for the help, I saw a reference to that program in another post that
didn't come up in my initial searches. However, I decided to just tell the
user (admin level anyway and mostly me) to go open the other database, it's
code that will not be used more than 4 times a year.

Algy is talking about "dickie-birdies" and "hows your father?" I don't
understand him.

 

[John Nurick]

He was ever thus.

Thanks for the help, I saw a reference to that program in another post that
didn't come up in my initial searches. However, I decided to just tell the
user (admin level anyway and mostly me) to go open the other database, it's
code that will not be used more than 4 times a year.

Algy is talking about "dickie-birdies" and "hows your father?" I don't
understand him.