scheduling a table update

[gard0128]

Is it possible to schedule a process to update a table right from Access?

We are connecting a pivot table to an Access table, and would like to update (daily) the pivot table, without having to go into Access each day.

We are running against a table (versus a query) due to faster processing time.

Any ideas?

Thanks.

Gary

 

[drkhelmt]

Have you investigated running a Java or VB script by using scheduled tasks in Winblows? I haven't used them too much, but it may be an option for you.

Another option may be to have the onOpen even trigger an output. I use this to update a status report and it works fine since I have to open the database anyway when I get in in the morning.

Hope this gets you closer to the solution.

Andrew
a.k.a. Dark Helmet

"What's the matter Colonel Sandurz? Chicken?

 

[mp9]

Write VBA in your db to do the update, then create a macro with two actions - one to run your VB, and one to close the db. Then use the Handy Access Launcher (

http://www22.brinkster.com/accessory/ersources/001.shtml)

or similar to schedule the macro to be run at set intervals.