Call to shell stopped working

[Guest]

I had a routine that used to work fine

I run a batch file which needs a required value as a parameter. To make it convenient in an interface, there is a button which runs the batch file and supplies the parameter which is collected from a form. -- FileDat

I call the shell using the following line in VBA. This normally works on a day to day basis. (I have Windows XP

RetVal = Shell("J:\PRODUC~2\ELIGIB~1\LOAD_R~1\rx.bat " & FileDate & "", 1

My network administrator recently changed servers and claims everything is the same
But I keep getting a "Error 76 Path not found"

Yet, if I manually run the batch file using the console instead of my form, for example

Using the console, I change from C: to J
So that now I'm in the J drive where this Batch file is calle
and I call the file like this: rx.bat 04022

(At that point everything works fine

Why did my access VBA stop working? Why can't I call the line that always used to work
Please give me any idea what else I can chec

 

[Kelvin]

When the Network Admin changed servers, did he keep the same hard drive or
did he make a copy of the drive. If he did a copy, windows will sometimes
rename the 8.3 version of the filename and directories. It is possible that
the ~2 and ~1 you are using to describe the directory is not correct.

Kelvin

I had a routine that used to work fine.

I run a batch file which needs a required value as a parameter. To make it

convenient in an interface, there is a button which runs the batch file and
supplies the parameter which is collected from a form. -- FileDate

I call the shell using the following line in VBA. This normally works on

a day to day basis. (I have Windows XP)

 

[Guest]

Thank you. That was it
Produ~2 changed to Produ~