Batch Command to Run Macro Crashes

[dssrun]

I was wondering if anyone else had this problem: Anytime I run a batch command to run a macro with the DoCmd.OutputTO, access crashses and has to restart. But if I go into access itself and run the macro it works fine.

 
@echo off
cls
echo Running Weekly Macro
echo  -------------------
echo 1/1 Running Access Solution
"C:\Program Files\Microsoft Office\OFFICE12\Msaccess.exe"  "C:\Databases\Reports\dbWeeklyProcess.mdb"  /xweeklystatusreport
exit

[pbaldy]

I haven't had that problem, but since nobody else has answered, can you use Windows Scheduled Tasks instead of the batch file (or if you already are, run the Access file directly). That's how I fire off Access databases doing this type of thing, and I haven't had any problems.

[dssrun]

When you say run the access file directly, you mean go into the application and click on the macro? I run the file by either clicking my batch file icon or running from windows scheduler and both results produce the error.

[pbaldy]

No, I'm assuming you have an autoexec macro or something to fire off your process, so Scheduled Tasks would just open the db. Sounds like you've done that and still get the error. Is the PC logged in when it errors?

[dssrun]

Yes the PC is logged in. I physically click the RunReport.bat file.

I will have to look into this more, i have one database that is working fine with the OutputTo, both are the same format (.mdb) and it is a much larger report with 3 subreports so it is as complex as my reports get.