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

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.
pcalabriaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pcalabriaAuthor Commented:
@Pat. The problem is I can't find the MSAccess.exe program on the machines with the runtime installed.. did I miss it?
0
PatHartmanCommented:
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.
0
pcalabriaAuthor Commented:
Thanks!  I don’t know how I missed it the first time... found it in an office15 directory.. that solved the problem!
0
PatHartmanCommented:
I have trouble seeing what's in front of my face too :)  Glad you found it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.