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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xp component needed to open mdb file 2
close / rename linked .mdb file 20
how to open an mdb file has a database password form another mdb 1
how can I write a macro to import a txt file into a mdb file 1
Permissions / Closing MDB left open 1
detect password protected mdb's 3
Deployment for non-admin use - best practices 8
Copy Query from MDB to ADP 1

Back
Top