Need to programatically start a MS Access MDE using the Access Runtime

pcalabria
pcalabria used Ask the Experts™
on
I have an Access compiled program (Program.mde) which I need to start programmatically from another instance of access.
Is there any way I can start an Access MDE programmatically when the machine is using the Microsoft Access Runtime 2016?

When my code is executed on machines which have Access installed, I use:

strPath1 = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
strParameter = "C:\Disti-Master\Database\Inventory_Program.mde"

Call Shell(strPath1 & " " & strParameter)

MY PROBLEM OCCURS WHEN THE MACHINE USES THE MSACCESS RUNTIME.  
IN this case I can't figure out how to start the program using the shell command.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Distinguished Expert 2017
Commented:
The command would be the same.  If there are multiple versions of Access installed, including the runtime, the strPath1 needs to reference the version you want to run.  They are all named "MSACCESS.EXE" but they will be installed in different folders.  If only one version is installed, then you don't need the path, you can just use the strParameter value and Windows will figure out what program it needs to run.
pcalabria

Author

Commented:
@Pat. The problem is I can't find the MSAccess.exe program on the machines with the runtime installed.. did I miss it?
PatHartman
Distinguished Expert 2017

Commented:
Try omitting the path and just run the application.  If there is only a single version of Access installed, Windows will find it.  The location of MSACCESS.exe is dependent on where it was installed.  If you can't find it by searching, perhaps it got installed in a hidden directory.  I don't have any computer that has the runtime installed so I can't even look for you.
pcalabria

Author

Commented:
Thanks!  I don’t know how I missed it the first time... found it in an office15 directory.. that solved the problem!
PatHartman
Distinguished Expert 2017

Commented:
I have trouble seeing what's in front of my face too :)  Glad you found it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial