Task Schedular and Access

[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.

 

[Mark L. Ferguson]

You would need to write a script to run the update. You would need to
understand the use of the Application Object in Access
http://msdn.microsoft.com/en-us/library/aa716176(VS.60).aspx

--
Please use the Communities guidelines when posting.
http://www.microsoft.com/wn3/locales/help/help_en-us.htm
Use the "Ratings" feature. It helps the new users.
Mark L. Ferguson MS-MVP
https://mvp.support.microsoft.com/profile/Mark.Ferguson