schedule

[James]

Hi,

We are using Access 2000, a database has been setup for my
company, and there is a schedule somewhere, i am not sure
either within access or elsewhere to run an update at 12am
on a monday.

Is there a way of setting up a schedule in access 2000,
rather than using windows schuduler?

Thanks

 

[Nick Coe \(UK\)]

It's possible but tricky and fiddly. It also depends upon
what you mean by an update. If it's a replacement of the
application itself then no.

So, please expand, what do you mean by update?

Personally I'd tend to leave the schedule running as long as
it works without any problems. If it ain't broke, don't fix
it.

 

[Arvin Meyer]

Yes, by building a form that uses the Timer property, you can have a form
schedule an event. I would still prefer the built-in Windows scheduler. To
run an Access scheduler effectively, you must make sure the program stays
open all the time. That uses more machine resources than the Windows
schedulers. The Access Timer event is better used for repeated events within
the database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access