By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,472 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,472 IT Pros & Developers. It's quick & easy.

Spawning Access from Access

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a

"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.
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.