Running batch files in MSAccess 2010

[macca2153]

I have migrated to access 2010 from 2007. I had a macro which ran a batch file to call another application which worked in 2007 but does not work in 2010. The macro used the Run Application command which has a warning icon shown in design mode.
When I run the script the MS DOS screen flashes up showing the relevant commands but does not perform the actions.
I have tried to create a function using shell without any success including copying and editing script from the net.
Can anyone advise an approach which may help?

 

[Joe4]

This first thing you want to do is make sure that your batch file actually runs, independent of Access?
What happens if you try running the batch file directly (outside of Access)? Does it work then?
If your batch file calls certain programs (like Access or Excel), you may need to update your batch file code, as the Program executables are in different folders in different versions of Office.

 

[macca2153]

I have tested the batch file and it does run outside MSAccess

 

[Joe4]

Here are a few options you may want to check:
Running a batch file from a macro? - Access World Forums
General: Run Dos Batch files from Access

 

[macca2153]

Joe,
I currently have a macro with the Run Application command. The editor places a warning icon next to the command when I open the macro in design mode. When I run the macro, the MSDOS screen flashes up and closes but the batch file is not actioned. Note - the same macro works in Access 2007.
I tried the shell command with the same result.
Thanks for trying.

 

[Joe4]

What exactly does the batch file do?

 

[macca2153]

The batch file runs a program called Monarch which can be used to reformat data for use in a database. This batch files reformats several files.

 

[Joe4]

I don't understand why the batch file wouldn't run when called from Access, though I have never used Monarch before. These things can be hard to debug without having access to your environment.