how do I set up macro in access to run a query at a specific time.

T

TPratt

I'm sure the MVP's will have a better answer but if they don't....

I use the windows scheduler to kick off macros.

Set it up to run Microsoft Access at a specific time every day by using the
wizard first.

Then open the properties of the new scheduled task and, in the "Run" box, go
to the end of the data already there and type the following starting with a
space.

"Path of your database.mdb" /x NameOfYourMacro

It works pretty good and you can use the scheduler to compact a database as
well by typing /compact in place of the /x NameOfYourMacro.

T
 

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

Top