run the macro in Access automatically

[Ashley]

Is there a application I can use to run the macro in
Access automatically one a day? This is to replace a
person to actually go into the DB and run the macro.
This macro is for the report which need to include daily
updated data. I already have the macro output the report
to a folder in network.

Thanks

 

[Ken Snell]

Use Windows scheduler to open your ACCESS database at a fixed time. Set up
your desired macro under the name AutoExec. Then, when the database opens,
that macro will run automatically. Be sure to put the Application Quit macro
action as the last step in order to close the database when the macro is
done.