runApp adding directory path

[Ken Ivins]

I previously posted the below problem and no one responded (which I assume
means that they could not come up with an answer). So I did some more
experimentation on my own and came up some additional data. Maybe with this
information, someone can come up with an idea.

RunApp opens a number of other programs fine (both Microsoft and non
Microsoft). RunApp would not open a program from a shortcut though. So I
created a batch file (EMISbat.bat) that opened the C++ program (EMIS.exe)
that I placed in the same directory with EMIS.exe (the c:\aaa directory) It
opened it fine from Windows Explorer. The batch was quite simple:

c:\aaa\EMIS.exe

I then tried running the batch from RunApp. For the command line I entered
c:\aaa\EMISbat.bat and it would not work. I added a pause to the batch file
to see what was happening and noticed that something was added to my
command. The following command showed in the DOS window: C:\Documents and
Settings\Ken Ivins\My Documents\Customers>C:\AAA\EMIS.exe

I then changed the batch to:

cd C:\

cd C:\aaa

C:\AAA\EMIS.exe

Then it all worked fine. Any idea why Access/Windows is adding the other
directory information? Is there a way to stop this?

Thanks,
Ken Ivins



I am trying to run a simple C++ program that merges 3 ".asc" files into one
".asc" file from a RunApp Action in a Macro. I tried running it as a Windows
program and a dos program and still it did not work. I am using Access 2002
in a Win XP Pro environment.

The program runs fine by just double-clicking it. The Macro seems to start
the program. In the Dos mode a Dos window opens and then closes, but no new
file is created.

Any ideas why this is not working correctly?

Thanks,
Ken Ivins