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
0
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.
0
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.
0

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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
0
Ingx_SubAuthor Commented:
Is there a Java script that could be written to do that?
0
jadedataMS Access Systems CreatorCommented:
You would have to check the Java Forum for that question...
0
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!
0
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.  
0
jadedataMS Access Systems CreatorCommented:
well there ya go then!!
0
AtropaCommented:
That is how I do it anyhow, but them I am a dumb swede so what do i know?
0
Ingx_SubAuthor Commented:
Where is this "task scheduler" ?
0
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
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.