I have a batch file which runs a macro in an Access 2007 database. It takes hours for the Access code to run, so I want it to run overnight:
"C:\Program Files\Microsoft Office\Office12\msaccess.exe" "c:\users\me\Documents\databasename.accdb" /x macroname
My goal is to schedule a task in the task scheduler so that this macro will run at midnight. I am just looking for a plan B in case I don't have permissions to set up a task and there are issues with IT doing this for me. Is it possible to put a 7 hour delay in the batch file? In this way, we could run the batch file at 5pm and it wouldn't run the Access macro until midnight.
I see information on the internet concerning setting a delay for up to 99 seconds. Is it possible to set a delay for 7 hours?