Solved

Scheduling Jobs with MS Access?

Posted on 2003-12-08
12
1,036 Views
Last Modified: 2006-11-17
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?
0
Comment
Question by:Ingx_Sub
  • 5
  • 5
  • 2
12 Comments
 
LVL 32

Expert Comment

by:jadedata
ID: 9899745
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
 

Author Comment

by:Ingx_Sub
ID: 9899762
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
 
LVL 32

Accepted Solution

by:
jadedata earned 125 total points
ID: 9899843
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:Ingx_Sub
ID: 9899864
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
 

Author Comment

by:Ingx_Sub
ID: 9899868
Is there a Java script that could be written to do that?
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9899921
You would have to check the Java Forum for that question...
0
 

Author Comment

by:Ingx_Sub
ID: 9899925
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
 
LVL 5

Assisted Solution

by:Atropa
Atropa earned 125 total points
ID: 9899949
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
 
LVL 32

Expert Comment

by:jadedata
ID: 9899984
well there ya go then!!
0
 
LVL 5

Expert Comment

by:Atropa
ID: 9900043
That is how I do it anyhow, but them I am a dumb swede so what do i know?
0
 

Author Comment

by:Ingx_Sub
ID: 9920410
Where is this "task scheduler" ?
0
 
LVL 32

Expert Comment

by:jadedata
ID: 10267193
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question