Automate a macro to run on a schedule.

MSAccess 2000 on a windows 2000 Network. I have a table that I would like to copy out of the database into another database. I have a macro to do that but what I'm trying to do is schedule for that macro to run every night. I seen a third party app that can schedule a macro it was like 35 bucks. I'm just looking for any alternatives.

LVL 2
jaze95Asked:
Who is Participating?
 
peter57rCommented:
Hello jaze95,

Use the Windows scheduler to start Access with your database. Look at Scheduled tasks in Control Panel.  You can specify a macro to run when the database opens in the command line using the /X macroname switch.
See command line in Help.

Pete
0
 
stevbeCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.