Access macro

S

subs

i have an update query that updates the database with new data. i
want to run this update query every thursday at 12 noon EST. is there
a macro that i can use to run such query on the same day and time
every week. Please help Thanks
 
J

John W. Vinson

i have an update query that updates the database with new data. i
want to run this update query every thursday at 12 noon EST. is there
a macro that i can use to run such query on the same day and time
every week. Please help Thanks
Click to expand...

Your best bet is to use the Windows Scheduler to launch Access to run the
query. You can either have a dedicated database with a Startup Macro to launch
the query, or open a frontend to the database using the /X command line switch
to eXecute a macro which runs the query.
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Need Help with Macro Security 1
Updates for excel 2002/3 0
Integrating information from Word to Excel (not mail merge) 1
Making a macro only work on certain files 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top