running batch file

[jekirksey]

I have the line

Shell "C:\program files\programname\batchfile.bat"

on the on open event of a form, but when it runs it gets the error message that the CMD.exe was started with the above path as the current directory (a UNC) CMD will now default to the windows directory..but nothing ever happens. any ideas.

 

[NJudson]

If I remember correctly I think I had a similar problem a while back and solved it by either placing the batchfile directly on c:\ or in a subfolder on c:\ but I couldn't have multiple subfolders beyond that. Anyway, give that a shot. As for the cause of the error I have no idea.

HTH

 

[ghudson]

Try this...

Run Dos Batch files from Access

Although, I can not get it to work for Windows XP and Access 97.

HTH