Spawning Access from Access

[Hank]

Hello,
Is it possible to spawn an Access program from another Access
program with out going to a batch file or something? I would like to
have an Access main menu and bring up a different front end Access
program depending on the menu selection. I'm using Access 2000.
Thanks,
Hank Reed

[Tom van Stiphout]

On 27 Dec 2004 05:26:34 -0800, "Hank" <ha********@aol.com> wrote:

Sure. You can use Automation like this:
dim o as new Access.Application
o.visible=true
o.OpenCurrentDatabase "c:\two.mdb", False

-Tom.

Hello,
Is it possible to spawn an Access program from another Access
program with out going to a batch file or something? I would like to
have an Access main menu and bring up a different front end Access
program depending on the menu selection. I'm using Access 2000.
Thanks,
Hank Reed

[Mr. T]

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:27********************************@4ax.com...

On 27 Dec 2004 05:26:34 -0800, "Hank" <ha********@aol.com> wrote:

Sure. You can use Automation like this:
dim o as new Access.Application
o.visible=true
o.OpenCurrentDatabase "c:\two.mdb", False

There is also the Shell command.

You can create a number of databases in one mdb file. Unless the 'separate
databases are really big, this is a practical solution.

[Wayne Gillespie]

On 27 Dec 2004 05:26:34 -0800, "Hank" <ha********@aol.com> wrote:

Hello,
Is it possible to spawn an Access program from another Access
program with out going to a batch file or something? I would like to
have an Access main menu and bring up a different front end Access
program depending on the menu selection. I'm using Access 2000.
Thanks,
Hank Reed

See the TSISOON utility at www.trigeminal.com
Wayne Gillespie
Gosford NSW Australia