Ingx_Sub
asked on
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?
Is this possible?
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
I can't set a "timer" in Access so that once it hits 7:30, it runs the query and updates the table?
Bummer
ASKER
Is there a Java script that could be written to do that?
You would have to check the Java Forum for that question...
ASKER
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!
Thanks Jack!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
well there ya go then!!
That is how I do it anyhow, but them I am a dumb swede so what do i know?
ASKER
Where is this "task scheduler" ?
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
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
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