Can I open another Database from a comand button

[NightOwl]

Can I open another Database from a comand button on a form and not have the database with the open button close?
Eg..I have Db1 open and I wish to open Db2 do some work in it, then close Db2 and have Db1 as it was before I opened Db2 .
If this is possible, how would I do it?
I have never used VBA in Access..so I'm not too sure I could do that
TIA
Jacki

 

[TheToeOfPooh]

One possible option.

Instead of using a Command Button how about using a Hyperlink?

e.g.
Open your Menu\Switchboard form in Design View

Go to Toolbar option Insert
Choose Hyperlink from drop down list
Select the database you want to open

If this meets your needs you could then "Attach" this Hyperlink to a Command Button - have the Hyperlink activated when an On Click event occurs.

HTH
Bernard

 

[Norie]

I wish to open Db2 do some work in it

What 'work' do you want to do on it?

 

[NightOwl]

Thanks Bernard,
I never considered attaching a hyperlink to a command button. Great idea!!
I know I could just link to Db2 but I just wanted to know if it was possible to do it this way. So... thanks Heaps
Regards
Jacqui