Run a query in a closed mdb file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top