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/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Switchboard buttons stop working 3
Access Command to run access, open to specific form and specific record 1
Access Switchboard error message 1
Switchboard form to open another form based on combo criteria 6
Calling Access 'form' from other applications 0
Code works in 2003 not 2007 4
Access Switchboard not Working - Private Function HandleButtonClick 1
Simple password 2

Back
Top