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\
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.
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\
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Thanks! I don’t know how I missed it the first time... found it in an office15 directory.. that solved the problem!
I have trouble seeing what's in front of my face too :) Glad you found it.
ASKER