scheduling MS access macro to run

[boboleft]

I have built a MS access macro to automatically truncate table and import the data. Does anybody know how to schedule the macro to run automatically and output the file to a folder??

thanks

 

[danvlas]

Use the Windows Task Scheduler to open your Access database at the desired time (or interval)

The Access database should have a startup form that does what's needed in the Load Event and then quit the application.

HTH


Daniel Vlas
Systems Consultant

 

[boboleft]

Thanks..where do I find windows task scheduler to open the MS db?? Can you share the steps??

Thanks again!!

 

[dhookom]

boboleft,
Where have you looked? Did you take the time to look through the programs in the Start menu?

Check Accessories->System Tools...

Duane
Hook'D on Access
MS Access MVP

 

[danvlas]

http://www.iopus.com/guides/winscheduler.htm

Daniel Vlas
Systems Consultant

 

[boboleft]

sorry, didn't know that was in the start< program menu. thanks for the help.