I have a few queries that pull data from a couple of ODBC sources. Currently I go into the database and use a command button to run the process to bring the data upto date. Is there a way I can automate this to run daily?
The database sits on the network, but I potentially could have a workstation permanently logged in... ...what can I use to trigger the code by time of day?

Ben, you can create a form that has a Timer event. Set the form's Timer Inverval to check once per hour, for example. When the desired time of day occurs, use the DoCmd.RunSQL code to run the queries. To turn your queries into SQL code just open them up in design view and click VIEW > SQL VIEW to get the statement.

Have a flag, say, fDone set false and when the SQL is run, set it to true so that the queries don't run for the rest of the day. Then at midnight, set the flag back to false.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Or you can link to the data instead.



Sal

Linking to the source wasn't an option as the data is transient. I've utilised Task Scheduler and have scheduled a seperate DB with an autoexec to execute the passthrough queries and the main db now links to the data in this.