Hello,
I have the following code in place in a VBA application that works just fine:
Shell("c:\program files\microsoft office\office11\msaccess.exe Z:\DrawingMgrPROG.adp", vbMaximizedFocus)
However, this code requires that the machine using my application have a mapped drive (Z) to the correct location. When I have replaced the "Z" with the full network path, the code generates the following error - "The command line you used to start Microsoft Office Access contains an option that Microsoft Office Access doesn't recognize. Exit and restart Microsoft Office Access using valid command-line options." How do I use this code without using a mapped drive.
Thanks in advance for any help,
T-Tops
I have the following code in place in a VBA application that works just fine:
Shell("c:\program files\microsoft office\office11\msaccess.exe Z:\DrawingMgrPROG.adp", vbMaximizedFocus)
However, this code requires that the machine using my application have a mapped drive (Z) to the correct location. When I have replaced the "Z" with the full network path, the code generates the following error - "The command line you used to start Microsoft Office Access contains an option that Microsoft Office Access doesn't recognize. Exit and restart Microsoft Office Access using valid command-line options." How do I use this code without using a mapped drive.
Thanks in advance for any help,
T-Tops