Failsafe ways to open Access and run a macro and close

[CedarTree]

Hi... looking for best ways to use Windows task scheduler to open up Access (not hidden!), run a macro, and auto close. Say once a day. Use a batch file maybe? Sample code please? Thanks!!!

 

[tvanstiphout]

Zero code needed. Read up on the command line switches for msaccess.exe, especially the /x switch.

 

[Isaac]

Look into VBScript that opens access (set obj = createobject("access.application"), then set db=obj.opencurrentdatabase("path"), then access vba from there.

No ideas about macros, wouldn't use one. use vba instead.

 

[Isaac]

or just use the windows task to open a database that's set to run something when it opens (startup form, form_load event code, code includes application.quit).

 

[CedarTree]

Zero code needed. Read up on the command line switches for msaccess.exe, especially the /x switch.

So I'm guessing I set-up a CMD line bat file that I run on a schedule?

 

[Isaac]

I think he means in the action of the Task you can paste in a shortcut path with a switch directly

 

[GPGeorge]

Hi... looking for best ways to use Windows task scheduler to open up Access (not hidden!), run a macro, and auto close. Say once a day. Use a batch file maybe? Sample code please? Thanks!!!

What Tom suggested...

Look at the options for Task Scheduler tasks.

Put MSAccess.exe in the Program to Run Setting.
Add the appropriate command line setting to open a specific accdb and run a specific macro when that accdb opens. For details, you can search online for command line options for Access.

 

[GPGeorge]

BTW, Nothing was ever FailSafe, nor ever will be.