Solved

Scheduling Jobs with MS Access?

Posted on 2003-12-08
12
1,015 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:Ingx_Sub
Comment Utility
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
Comment Utility
Is there a Java script that could be written to do that?
0
 
LVL 32

Expert Comment

by:jadedata
Comment Utility
You would have to check the Java Forum for that question...
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:Ingx_Sub
Comment Utility
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
Comment Utility
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
Comment Utility
well there ya go then!!
0
 
LVL 5

Expert Comment

by:Atropa
Comment Utility
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
Comment Utility
Where is this "task scheduler" ?
0
 
LVL 32

Expert Comment

by:jadedata
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now