Scheduler

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Does anyone know of a good third party scheduler that will run access
queries?

Thanks,
Chris
 
Dear Chris:

Likely, you want to run an "action query", right? Not one that returns
results for you to look at, but one that changes the database, inserting,
deleting, and or updating things.

I recommend you create a separate Access file whose startup is to perform
this action and just use the scheduler that comes with windows. It can open
that database which will perfrom the action. The database can close itself
if desired when it completes. You may want to leave some message that it
was done, perhaps sending an email.

Tom Ellison
 
Thanks Tom. Would I be able to run macros through the windows scheduler?
Is the setup pretty intuitive? Have you done this yourself?

Thanks,
Chris
 
Dear Chris:

You can run a macro by naming it "Autoexec". When you open a database, this
macro will be executed. All you need do is schedule a command line that
executes Access with this database.

I have done this a few times.

Tom Ellison
 
Back
Top