Run a query in a closed mdb file

N

Novice

I have the following situation:
1) Users update some mdb file during the day (up to 6pm);
2) At 9pm some update queries have to be executed and the txt file has to be
created.
How to implement the second part? How to initiate Access program using Timer?
 
O

Ofer Cohen

Use wndows schedular to run the MDB in a certain hour.
Create a macro called AutoExec, which runs as the MDB opens, that run the
queries ans export the text file.
 
Top