I want to create a batch file that will run the macro in my access mdb and will close Access once completed and then will log the date and time the batch file ran into a log.txt..
I tried this but it does only the macro...
START
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:
\Test\Test.MDB" /x Test_Macro
TASKKILL /F /IM msaccess.exe /T
echo Process is finished succesfully at %TIME%, %DATE% >> c:
\Test\log.txt
SLEEP 360
GOTO END
:END