Windows Task Schedular and Update Query

[Beuferd]

Greetings.

I need to fire an Update Query in Microsoft Access at midnight, every night.

I figure Task Schedular is what I'm looking for.

I've set up a reminder to pop up on my screen everyday at midnight.

This becomes an issue on nights I've had too much to drink!!

Can I make Schedular run an update query in Access at a set time everyday?
I haven't a clue how to program, but if someone could point me to some
links..or better yet...give me some examples of what I need to do...I would
be most grateful.

Thank you ahead of time.

 

[Daniel Pineault]

One approach would be to create a macro which run your query. Then setup a
scheduled task to launch your macro. Check out the following post

http://groups.google.ca/group/micro...read/thread/526759142b956c19/ad4607e5ad9c8a48
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Beuferd]

Daniel--

Thank you very much! This is exactly what I needed.
Have a good one.

 

[mary r]

Hi! I'm trying to automate a scheduled refresh and cannot make any permanent
changes to the customer's security settings. Can I add an extension or
something to the scheduled task to bypass the MS Access security popup? The
database won't open to run the startup macro until the security window is
satisfied.

TIA-
-mary

 

[Albert D. Kallal]

Hi! I'm trying to automate a scheduled refresh and cannot make any
permanent
changes to the customer's security settings. Can I add an extension or
something to the scheduled task to bypass the MS Access security popup?
The
database won't open to run the startup macro until the security window is
satisfied.

TIA-
-mary

I think in this case you need to set your macro security to low...and then
you have no nags......

I have an article here that explains how to use/schedule access code with
the windows scheduler....

http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html

 

[mary r]

Thanks for the article, Albert.

Would I be able to, say, set macro security to Low in the script, run the
Access macro, then reset macro security to its previous level?

Making a permanent change to the customer's security setting is not an
option, and creating digital signatures for code that's at least 95% legacy
would be a last, last resort.

-mary

 

[Albert D. Kallal]

Thanks for the article, Albert.

Would I be able to, say, set macro security to Low in the script, run the
Access macro, then reset macro security to its previous level?

Making a permanent change to the customer's security setting is not an
option, and creating digital signatures for code that's at least 95%
legacy
would be a last, last resort.

We only had the macro security since 2003, and I do as a rule set macro
security to low.

I mean, it must be annoying for these people that every time they open
ms-access they receive a nag screen about macro security? (do they really
deal
with this issue this way all day long?).

Remember if the users don't have the registry locked down, then any other
program that they attempt to run could also set the macro security to low!
So, at the end of the day this is not really much security then? (this just
amounts to a NAG the users all day long kind of thing).

You are asking for the ability to have a process run something without any
kind of security prompt, and yet the company has a policy to have security
prompt in all their applications that run. I mean if they're bringing in a
contractor into the building, either they have a policy to give the person
keys to get in after hours, or the they don't. There's really not much you
can do here. Their policies means that you can't run the software
unattended, and it really that simple.

I suppose we could extend the sample script I have on my site to read the
macro security, then set the macro security low, and then run/launch
ms-access. Then set macro security back to what it was. The ability of the
script to do this is going to depend on permissions that users have. (think
vista will trigger a UAC prompt).

Some code for a script to read the registry can be found here:

http://www.activexperts.com/activmonitor/windowsmanagement/adminscripts/registry/

The value in the registry to set access macro security for 2003 is:

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

So, you can take the above code + above registry value and try this out.
Note that in above value of 1 = low).

If the above works, then add it to my sample script....

Another possibility is to have one computer setup in whch they set macro
securty = low (presumably this would be the computer in which the scheduled
task is to run at the given time). After all you're talking about scheduling
some kind of piece of software that's going to run unattended without any
user intervention.

 

[mary r]

Albert, you've helped put this into perspective - I do get tunnel-vision
sometimes!

You're right, it is an application that should run without user interaction.
They aren't running Vista, still using XP Pro and Access 2003. Furthermore,
this task should only be needed for the next year or so, until other upgrades
are in place. Nevertheless, it is needed as part of the transition, and my
customer wants it to be fully automated. *sigh*

Now that I think about it, the regular users do not get the security popup;
the macro security settings must be higher only on the server that my
development environment is on. Guess the next step will be to run all of
this by their IT/security guys and get their input. If they are willing to
reset the security level, fine - that's not a call I'm authorized to make,
but they are; otherwise, I'll have to script it as you described.

Thanks again for your very informative response!

-mary