Launch mde from another mde: fine tuning

  • Thread starter Thread starter slickdock
  • Start date Start date
S

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?
 
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.
 
Back
Top