Can we run a Macro automatically daily?

[dwight1]

I have a macro that i need to run daily. Is there a way I can schedule time for it to run automatically (like DTS)?

Thanks for the help.

 

[PHV]

Use the Task Scheduler for launching msaccess.exe with the /x switch:

http://office.microsoft.com/en-us/access/HP051883001033.aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dwight1]

Thank you for quick response. I will read through the tips.