How do I set a macro to run every 24 hours

[Michael]

I need to set a macro to run at a set time every day. I am using a database
to collect information from an external source. I am not at this computer
every day, and the information that I am retrieving is deleted every day. If
I don't get the information, it is lost. Is it possible to write a code to
make the macro run at a set time every day?

 

[Douglas J. Steele]

Use the Scheduling tool that's built into Windows, and pass it a command
line along the lines of:

"C:\Program Files\Office\msaccess.exe" "C:\Data\MyDatabase.mdb" /x MyMacro

 

[Albert D. Kallal]

I need to set a macro to run at a set time every day. I am using a
database
to collect information from an external source. I am not at this computer
every day, and the information that I am retrieving is deleted every day.
If
I don't get the information, it is lost. Is it possible to write a code
to
make the macro run at a set time every day?

I explain a possible solution here:

http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html