I know that, while I have a database open, I can open another session of Access 2000, open another database, then close the current database and session via VBA code and/or macros.
I need to be able to open one session of Access with one database(A) and then, without closing the current Access session, open another database(B) and close the original one(A).
Basically I am running a menu system of sorts and it would be much smoother if I could keep one Access session open at all times vs. closing and opening the software everytime I change DB’s.
Any ideas? I’m writing mosting in VBA.
Thanks.
Tom H.