How do I run another access database on the form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What syntax can I key so I can ask access to run another access database from
another location. I am trying to use "Run Code" in the switchboard to direct
me there but I just dunno what is the rgiht code.
 
Hi,

To launch a new instance as if you have double clicked the MDB files you
could use the Shell Function:

Shell "D:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE
D:\SomePath\Some File.mdb", vbNormalFocus

Just change the Command Line parameter as appropriate.

--
HTH

Mark Phillipson

Free Add-Ins at; http://mphillipson.users.btopenworld.com/
 
Back
Top