Shell command won't work using file server path

[RLN]

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.e xe " & "U:\Access_EQ\E Q-NonCorp.MDB"
Call Shell(strAppNam e, 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\Fin ancial Accounting Restricted\Acce ss_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.e xe " & "\\kcnccp50y\Fi nancial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB".
Call Shell(strAppNam e, 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

[paii, Ron]

"RLN" <rl************ ***@yahoo.com> wrote in message
news:11******** **************@ j33g2000cwa.goo glegroups.com.. .

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.e xe " & "U:\Access_EQ\E Q-NonCorp.MDB"
Call Shell(strAppNam e, 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\Fin ancial Accounting Restricted\Acce ss_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.e xe " & "\\kcnccp50y\Fi nancial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB".
Call Shell(strAppNam e, 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

Try adding double quotes around your path so the shell command receives the
path with quotes

stAppName = "msaccess.e xe " & """\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB""".

[RLN]

Try adding double quotes around your path so the shell command receives the
path with quotes

Global Const gblPgmPath = ""\\kcnccp50y\F inancial Accounting
Restricted\Acce ss_EQ\Corp\""
Actually, I have it declared like you see above, but I want to use it
in a variable, 'gblPgmPath' then reference it in various locations in
the application (in Shell statements and other code) like:
stAppName = "msaccess.e xe " & gblPgmPath
The problem here is when I compile, I get an error "Expected
Expression" & the compiler highlights the 2nd forward slash in the
"global const" line of code as I have referenced above.

Due to this error, am I stuck hard coding it in my application like
this:
stAppName = "msaccess.e xe " & """\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB"""

Thanks.

[Ron2006]

Was this a type for your message? In one place it is:

Global Const gblPgmPath = ""\\kcnccp50y\F inancial Accounting
Restricted\Acce ss_EQ\Corp\""
but then later you say it is:

"""\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB"""

In one place it is \Corp\ in the other place it is \NonCorp\
In one place you include the mdb name in the other palce you do
not..

stAppName = "msaccess.e xe " & gblPgmPath
(without mdb name)

and then:
stAppName = "msaccess.e xe " & """\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB"""

[RLN]

stAppName = "msaccess.e xe " & """\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB"""

this worked! Thank you.
Ron2006 wrote:

Was this a type for your message? In one place it is:

Global Const gblPgmPath = ""\\kcnccp50y\F inancial Accounting
Restricted\Acce ss_EQ\Corp\""
but then later you say it is:

"""\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB"""

In one place it is \Corp\ in the other place it is \NonCorp\
In one place you include the mdb name in the other palce you do
not..

stAppName = "msaccess.e xe " & gblPgmPath
(without mdb name)

and then:
stAppName = "msaccess.e xe " & """\\kcnccp50y\ Financial Accounting
Restricted\Acce ss_EQ\NonCorp\E Q-NonCorp.MDB"""