Task Schedular and Access

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.
--
Big Beu

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/libr...76(VS.60).aspx

--
Please use the Communities guidelines when posting.
http://www.microsoft.com/wn3/locales...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

"Beuferd" <> wrote in message
news:443DFC22-8AD8-4215-AB1B-...
> 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.
> --
> Big Beu