Automatically run macro overnight

[kdbailey]

I would like to run an access macro overnight, the macro is set to a button click though. How can I set a windows scheduler to run this click at a specific time? The name of the macro is "Update".

[pbaldy]

I would change the name of the macro to autoexec and then it will run automatically. You can do this on a copy if desired. Alternatively I think there's a command line switch to run the macro, but I've never used it.

[kdbailey]

Well I don't want it to auto run every time I open the database, so I'd rather not have it be an autoexec. I'd rather it be a prompted command through the task scheduler, I just don't really know how to do this.

[pbaldy]

Well, like I said you could use a copy for this. That said, look at command line switches in help. I believe there's a /macro or something like that.

[kdbailey]

I'll take a look.