I would use the the Windows task scheduler or any other scheduling product.
Using the windows scheduler...
-  add a Scheduled Task
-  migrate to Microsoft Access as the program you want to run
-  when you've completed the wizard, right click to view the properties of
the new task
   -  you'll need to add the path of your database, in quotes, to the end
of the existing string in the "Run" box.
   -  then, at the end of the path you just added, enter the following...
/x NameOfMacro
       -  it should look something like this:  "C:\Program Files\Microsoft
Office\Office\msaccess.exe" "C:\My Documents\MyDatabase.mdb" /x NameOfMacro
           --the first part may vary depending on the version of Access
you're running--

That should do it