Code to open a DB

A

AFKAFB

All
I've a form with four command buttons.
Selecting the first button allows the user to use the current DB.
However, clicking any of the other three buttons should close the
current DB and open up a new DB, e.g. DB_2.mdb, DB_3.mdb etc...
Preferable the user should not notice the current DB has closed.
I cannot use the same DB s there are chinese walls issues and the data
needs to be ring-fenced at all times.
Regards
Chris
 
F

fredg

All
I've a form with four command buttons.
Selecting the first button allows the user to use the current DB.
However, clicking any of the other three buttons should close the
current DB and open up a new DB, e.g. DB_2.mdb, DB_3.mdb etc...
Preferable the user should not notice the current DB has closed.
I cannot use the same DB s there are chinese walls issues and the data
needs to be ring-fenced at all times.
Regards
Chris
Click to expand...

Application.FollowHyperlink "c:\FolderName\Db2.mdb"
DoCmd.Close acForm, Me.Name
 
Top