Launch mde from another mde: fine tuning

[slickdock]

I'm using shell to launch an Access 2002 mdb from another mdb file with this
command:

Shell SysCmd(acSysCmdAccessDir) & "MsAccess.Exe " _
& """C:\Program Files\MyApp\MyApp_fe.mdb "" /wrkgrp ""C:\Program
Files\MyApp\secured.mdw"" /user operator"

I need some fine tuning:

1. It opens, but does not become the active window. I have to alt-tab to get
to it. How can I make it the active window?

2. It opens, but not maximized. How can I make it open with a maximized
window?

3. The doozie: How can I carry a value from the current form in DB1 to the
newly opened DB2?

 

[Daniel Pineault]

Since you wish to actually manipulate the new database instance... You'll
need to change the way you work and connect using DAO or ADO. The following
link briefly illustrates how-to make the basic connection

http://www.vbmonster.com/Uwe/Forum.aspx/vb-dao/466/DAO-connect-string

Pay attention as there is a minor typo that get corrected a post or 2
further in the discussion.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.