Error using RunApp

[Sean Stevens]

I have a very simple .bat file that I invoke from a macro in Access 2003, which deletes a file on my d: drive.

This macro works fine on my PC and a colleagues. However, on another user's PC it gives an error;

"MS Access can't invoke the application using the RunApp action. The path to the application is invalid, or a component of the application is missing."

I have checked the path and it is correct and the .bat file runs fine from windows explorer. Any idea what can be causing this??

 

[Norie]

Sean

How exactly are you running the bat file?

 

[Sean Stevens]

Sean

How exactly are you running the bat file?

Using RunApp with the below as the Command Line;

d:\healthchecks\delete.bat

 

[Norie]

Sean

I don't think I've ever heard/seen of RunApp being used to run a bat file.

Why not just use Shelll?

Or even create code that uses Kill to delete the files?

 

[Sean Stevens]

Sean

I don't think I've ever heard/seen of RunApp being used to run a bat file.

Why not just use Shelll?

Or even create code that uses Kill to delete the files?

Thanks for the help - I am picking up the support of an Access application after a colleague has left. Never used Access macros before, but I am proficient in Excel VBA. How do I invoke the two methods you have mentioned above?

 

[Sean Stevens]

I can write the VBA to do the delete via the Kill statement. How do I execute the VBA from within an Access macro?

 

[Sean Stevens]

Worked out how to do it - was missing the parantheses from my function name in the RunCode statement.

Thanks for the help.

 

[Norie]

Sean

Why not convert the macros to VBA?