Opening Access Database from within Code - TechRepublic
General discussion
April 28, 2002 at 02:17 PM
haycoconsulting

Opening Access Database from within Code

by haycoconsulting . Updated 23 years, 11 months ago

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.

This discussion is locked

All Comments