variable msaccess.exe path in shortcut (1 Viewer)

[DataMiner]

Since I need to use command line variables (like \exe), my shortcut paths must contain the msaccess.exe path. But it varies in different environments, and this is NOT under my control. For example, on our citrix servers, the path starts with c:\program files (x86)\MS Office
whereas on most PC's it starts with c:\progam files\MS Office

Is there a way to tell a shortcut that the path is something on the order of c:\*msaccess.exe

 

[ghudson]

You will have to use code to create a custom shortcut since you do not know where the msaccess.exe is located.

Environ("ProgramFiles") will tell you where the program files are located on the current computer.

Now you need to find some VBA to create the shortcut with the switches you want... Google access vba create shortcut