Opening the second db, then close the first.

  • Thread starter Thread starter GPO
  • Start date Start date
G

GPO

I want to:
1. Open database A manually.
2. Open database B from code in database A.
3. Use database A to run code in database B (I guess by
using references to B).
4. Use the code in database B to then close database A
leaving B open (this is the bit I can't figure out).

Regards

GPO
 
This is a bit messy but if you
1. open dbA and run the code (CodeA) however you want to launch it.
2. Code A opens dbB using Shell function possibly with a passed argument
that dbB reads when it opens to run Code B
3. Code A then closes dbA
4. Code B loops with delays testing to see if dbB is open (you can look for
an LDB file and try to kill it if it is not found or allows itself to be
deleted then the dbA is not open) make sure that you don't endlessly loop.
5. Code B does what ever you want to do.
 
Back
Top