Switch Databases

  • Thread starter Thread starter fofa
  • Start date Start date
F

fofa

Searched but did not find. Came close with some code to open a second DB
in a new instance of Access, but does not work for me. Here is what I
need, hopefully someone can clue me in.
_Within_the_same_instance_of_MSaccess_ I need to open a second DB and
close the first (or make it unavailable while the second instance is
running), run the startup (or send it a startup form) from a button in
the first DB, then when done, close that second DB and reopen the first
one. But I can't open a second instance of MSaccess to do this
(security won't let me).
Any idea on how to do this, and if I close the original instance of
access, it terminates the session (security)?
Thanks
 
Back
Top