central access database

[Guest]

I have 3 databases that perform 3 different things.

I would like to have one main menu and the user can go click on the name of
the database he wants to open rather than having all these databases sitting
on his desk top. This way all the databases and handled thru one screen.


How do i do this??? Any cons on the are welcome. I am just starting on this.
Please help.

Thanks.

 

[bob]

You are not giving us a lot of info - but a best guess is that you can make
one user interface for all them by combining them into one front-end...the
front-end can have many databases on the back-end.

Bob

 

[Guest]

How can i do this???

You are not giving us a lot of info - but a best guess is that you can make
one user interface for all them by combining them into one front-end...the
front-end can have many databases on the back-end.

Bob

 

[johngo]

I have 3 databases that perform 3 different things.

I would like to have one main menu and the user can go click on the name of
thedatabasehe wants toopenrather than having all these databases sitting
on his desk top. This way all the databases and handled thru one screen.

How do i do this??? Any cons on the are welcome. I am just starting on this.
Please help.

Thanks.

You can use the Shell command like so.

Dim vAppID


vAppID = Shell("msaccess.exe [Full Path to Access Db]",
vbNormalFocus)
AppActivate vAppID, True
Application.Quit

If you remove the quit line the initial database will remain open.

 

[johngo]

I have 3 databases that perform 3 different things.

I would like to have one main menu and the user can go click on the name of
thedatabasehe wants toopenrather than having all these databases sitting
on his desk top. This way all the databases and handled thru one screen.

How do i do this??? Any cons on the are welcome. I am just starting on this.
Please help.

Thanks.

You can use the Shell command like so.

Dim vAppID


vAppID = Shell("msaccess.exe " & sDesktopFolder & sAppFile,
vbNormalFocus)
AppActivate vAppID, True

Application.Quit

If you remove the quit line the database running the shell command
will remain open.