Scheduling in Access?

[Scott]

I am currently using access 97..I have a macro program
that opens access and runs the macros on certain day.

This program is not very good.

Is there a way to schedule this in access?

I have a bunch of macros called monday downloads, tuesday
downloads, etc.

I need to run these on certain days at certain times

Thanks
Scott

 

[Van T. Dinh]

Have you tried using the Windows Scheduler?

 

[Scott]

I am using windows NT at work. I dont believe there is a
windows scheduler in there.

I can leave access open over night.

Just trying to figure out how to run certain macros on
certain days.

Scott

 

[Jim/Chris]

You can use the Windows Task Scheduler to accomplish this.

Jim

 

[Stuart Kirk]

Scott

Access doesn't like being left open for long periods of time, I've had
occasions where it has bloated out of all recognition, and even got
corrupted.

Good to use the Windows Scheduler to open the database.

Set a form to be the Startup form, then put a bit of code in the OnOpen
event to work out what day it is and take the appropriate action.

Something like:-

SELECT CASE WeekDay(Date)
CASE 1
'do something for Sunday
CASE 2
'do something for Monday
etc etc
END SELECT

Then when you've finished whatever it is, close the application down:-

DoCmd.Quit acQuitSaveAll

Hope that helps

Stuart

 

[Arvin Meyer]

I am using windows NT at work. I dont believe there is a
windows scheduler in there.

Yes there is. They are called AT commands. You can access them from the
command line or use WinAT from the Resource Kit.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[lin lin]

Have you tried using the Windows Scheduler?