Scheduler

[darrell]

Does anyone schedule Access queries/exports to run off
hours so they don't effect the performance on users
machines. I have a couple of queries that export a large
amount of data the exports can effect the performance on
a users machine. I also like to run after hours when
there will be no changes to the data.

What type of scheduler software do you use or is there
any that works with Access?

 

[M.L. Sco Scofield]

Although Access (and all of the Office programs) is not designed to be run unattended, if you make sure that you've included error
handling in *everything* that could go wrong and display a message, you might get away it.

I'd seriously consider writing a VB or C# program for an application like this.

As far as a scheduler, how about just using the scheduler built into Windows. I works well and it's already there which makes it
quit inexpensive.

With all of that said, take a look at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;288366
http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757
http://support.microsoft.com/default.aspx?scid=kb;en-us;210317

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[dtroupe]

I am using a program called WindowsScheduler and it runs
exe, com and bat files. Int the bat file I have the name
of the macro in Access that runs around the clock. You can
set it to do what you want, very flexable and runs in
WinNT too. I have it importing from text file to Access
and transfering text out by query to HTML (every 15
minutes). Works better than an alarm clock.

-----Original Message-----
Although Access (and all of the Office programs) is not

designed to be run unattended, if you make sure that
you've included error

handling in *everything* that could go wrong and display

a message, you might get away it.

I'd seriously consider writing a VB or C# program for an application like this.

As far as a scheduler, how about just using the scheduler

built into Windows. I works well and it's already there
which makes it

quit inexpensive.

With all of that said, take a look at:
http://support.microsoft.com/default.aspx?scid=kb;en- us;288366
us;210317

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

"darrell" <[email protected]> wrote in

message news:[email protected]...