I have an Access app that shells out to run the file transfer program PSCP.exe. It runs fine on XP and Windows 7 32 bit machines.
On Windows 7 - 64 bit machines it runs fine from the command prompt but not when I shell out to it. My shell command is the same as I use for the XP machines:
x = shell("C:\BioRemote\BioSend.cmd",1)
One of the lines in the .cmd calls on the PSCP programs:
> C:\Windows\System32\PSCP.exe -pw PASSWORD DestPathFile SourcePathFile:
When the above line executes on a 64 bit machine from the Command window, it runs just like it should. But if I run the .cmd by shelling from Access's intermediate window, the message comes back:
"'C:\Windows\System32\PSCP.exe' is not recognized as an internal or external command, operable program or batch file."
Other commands within the .cmd such as "Ren a.txt b.txt" work fine, and other executables such as "C:\Program Files (x86)\VPN Client\vpnclient" also work fine.
Any help would be appreciated.