Scheduling Jobs with MS Access?

Is it possible to set up Access so that it runs a specifc query every day at 7:30pm?  This query would be an update query, which will update the data on a current table, appending, and deleting records when needed.

Is this possible?
Ingx_SubAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jadedataMS Access Systems CreatorCommented:
Hey Ingx_Sub!

  By building the job into a database to run as the database is opened you can have a server CRON a job to open the database
  which inturn launches the job inside the database
  which does an application.quit when the job completes
  You might want the db to log the process as the job ensues.

regards
Jack
Ingx_SubAuthor Commented:
Does that mean Access can't do it?

I don't have access to create a CRON job on the server :(  And it would take months for me to get a DBA to do it for me.  I'm trying to avoid that route because I'd like to implement this process ASAP.
jadedataMS Access Systems CreatorCommented:
Create the same single job mdb with a single form inside.

 set the form timerinteval 10000 millisecs (10 minutes)
 put code on the form OnTimer event
  if time() >= #07:15:00 AM# and #07:45:00 AM# then
   'run the job
   'log the job
  endif


The database MUST be running constantly in order to do this however.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Ingx_SubAuthor Commented:
What do you mean the data must be running constantly?

I can't set a "timer" in Access so that once it hits 7:30, it runs the query and updates the table?

Bummer
Ingx_SubAuthor Commented:
Is there a Java script that could be written to do that?
jadedataMS Access Systems CreatorCommented:
You would have to check the Java Forum for that question...
Ingx_SubAuthor Commented:
Ok...I'll give them a shot.  I'll leave this one open for a while longer to see if anybody else has any suggestions.

Thanks Jack!
AtropaCommented:
Create a macro with the following

SetWarnings = No
OpenQuery = Opens your query
Quit

Using task scheduler (XP or 2000) create a scheduled task with the following command line..

"c:\program Files\Microsoft Office\Office10\MSACCESS.EXE \\Server\Share\Folder\NameOfDB.mdb /x MacroName"

Set it to run @ 7:30.  
jadedataMS Access Systems CreatorCommented:
well there ya go then!!
AtropaCommented:
That is how I do it anyhow, but them I am a dumb swede so what do i know?
Ingx_SubAuthor Commented:
Where is this "task scheduler" ?
jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Split: jadedata {http:#9899843} & Atropa {http:#9899949}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.