Selecting Which Database to Open

[Guest]

Good Evening all ....

First -- before I get beat'n up by the pros, which I am not, I have a
question.

I have three database (Access) programs that I have made adn we use at work.
I have figured out how to get the info back and forth .... but now I have
even a more basic question.

Is there a way I can send all users to a single point and let then for them
to select which program to go to. I can use the Call Shell command in the
switchboard but then the user has 2 access applications running. Is there a
way so only 1 will run?

Thanks in advance ... and Happy Holidays.

 

[fredg]

Good Evening all ....

First -- before I get beat'n up by the pros, which I am not, I have a
question.

I have three database (Access) programs that I have made adn we use at work.
I have figured out how to get the info back and forth .... but now I have
even a more basic question.

Is there a way I can send all users to a single point and let then for them
to select which program to go to. I can use the Call Shell command in the
switchboard but then the user has 2 access applications running. Is there a
way so only 1 will run?

Thanks in advance ... and Happy Holidays.

On each of your databases, or just the one that is used most ot the
time, code your switchboard command button click event:

Application.FollowHyperlink "C:\Path to Folder\DatabaseName.mdb"
DoCmd.Quit

Do the same for each of the other databases you wish to open.
The current Db will close when the other opens.