Open another database and close the current one

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
Click to expand...
 
Back
Top