Run a Query at a specific time (1 Viewer)

[yahazim]

I have an Access database connected to a SQL Server backend. All tables are linked.

I have a query that I want to run at downtime every evening at 2am, PST. I want to save the results of this query so that I can run a Report the next morning on the results of that query.

How do I do this? Thank you in advance for your clear advice.

Jim

 

[jwindon]

Don't know about that clear advice thing, but first .....the database will remain open all night and active correct?

You could create some kind event OnTimer that check the value of Now() and fires to run the import procedure if the time is > 2am but less than ? (depends on the interval you set)

Just a thought.

 

[yahazim]

Would I then save the results of the Query to a table?

Or would it be better to create a Report and save the results of the Report to a file?

Thanks!

Jim