Scheduling Macro

[raccess]

Hi,

Here is scenario, I have one application in MS Access 2000 in that I wrote one Macro to read data from text file and add into respective tables. Now I want to automate this process through some kind of scheduling.

Every month end I’m getting text file with data and then I want to run this macro to add data.

Any idea how I can call this macro from some outside process/script? How i can automate it?
Thanks in Advance,

Raccess

 

[perrymans]

It is fairly common to execute on a given day, or at a given time on a given day, or at start-up or OnEvent. You want it executed from outside the database? I know it can be done, try google and see below link.

Sean.

http://j2eeadvisor.com/doc/00125

 

[raccess]

Yes i want to execute it from outside of database - using some scheduling process on each first day of month.

 

[perrymans]

I would suggest a form which has the Date/Time in a textbox, and triggfer the event when it hits that date/time.

I think it much easier to trigger it from inside Access, than outside. You could even put it in your start-up so that it checks the date, and if it is the 1st of the month, then it executes your query.

I have done a thread on this before, but I can't find it, or the sample db I used. If I come across it, I'll let you know.

Sean.

 

[JC3]

You can try creating a shortcut to your macro in a directory on your PC or network by dragging the macro from Access to the directory window.

Then you can drag that shortcut into the Task Sceduler (Control Panel). Right click on the task you just created and click "Properties" to set up the schedule.

 

[JeroenNL]

Using the Task Scheduler (as JC3 proposed) is a very good way to accomplish this. I use the Task Scheduler to run a macro on a daily basis and everything runs OK.

Bye,
Jeroen

A 3d level editor in Delphi

http://www.gamefortress.com/~delgine

 

[mp9]

Alternatively, use the freeware Handy Access Launcher which is kind of a mini task scheduler specificalyl designed for scheduling Access db admin tasks and macro runs. Get it from

http://www.geocities.com/waddly/accory.html