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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.