Re: Access 2003/WinXP Pro-SP3
I have a shell command that does not run correctly.
I have two programs located on a file server: Pgm1.mdb and Pgm2.mdb
Pgm1 launches Pgm2 via a command button using a shell command.
The old method ran fine when the specified file server was mapped on
the user's workstation as a drive letter (U)
strAppName = "msaccess.exe " & "U:\Access_EQ\EQ-NonCorp.MDB"
Call Shell(strAppName, 1)
However, hard coding the drive letter in the path is not wise, so I
wanted to specifiy the server this way by its full path:
\\kcnccp50y\Financial Accounting Restricted\Access_EQ\NonCorp\
(Pgm1.mdb uses this path very nicely when importing excel file from
this server, etc.)
When Pgm1 calls Pgm2 (they are in the same folder on the file server)
this does not work:
stAppName = "msaccess.exe " & "\\kcnccp50y\Financial Accounting
Restricted\Access_EQ\NonCorp\EQ-NonCorp.MDB".
Call Shell(strAppName, 1)
The error received is:
"The command line you used to start Microsoft Access contains an option
that Microsoft Access doesn't recognize."
Is there a work around for this so I can call another program using the
actual file server share name in lieu of a drive letter (which may or
may not be mapped correctly on every user's workstation?)
Thanks,
RLN