• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1102
  • Last Modified:

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?
0
Ingx_Sub
Asked:
Ingx_Sub
  • 5
  • 5
  • 2
2 Solutions
 
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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 5
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now