run query daily at a specified time

  • Thread starter Thread starter gls858
  • Start date Start date
G

gls858

My VB skills are just short of minimal. I would like to run a delete
query every day at a certain time. Is this possible?

gls858
 
My VB skills are just short of minimal. I would like to run a delete
query every day at a certain time. Is this possible?

gls858
Click to expand...

The simplest way is to write a Macro (let's call it RunTheDelete) which has
two steps: a RunQuery to execute the query, and a Quit to close the database.

Use the Windows Scheduler to schedule a daily task to launch Access and run
the macro. The command line would resemble

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"K:\SomePath\yourdatabase.mdb" /x RunTheDelete

all on one line (using the actual paths and filenames of course).


John W. Vinson [MVP]
 
John said:
The simplest way is to write a Macro (let's call it RunTheDelete) which has
two steps: a RunQuery to execute the query, and a Quit to close the database.

Use the Windows Scheduler to schedule a daily task to launch Access and run
the macro. The command line would resemble

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"K:\SomePath\yourdatabase.mdb" /x RunTheDelete

all on one line (using the actual paths and filenames of course).


John W. Vinson [MVP]
Click to expand...

Thanks John. I'll give it a try.

gls858
 
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

Email Excel Workbook Automatically Daily 3
Firefox Multi-Account Containers 1
hide the results of a query 6
group by query 3
group by first three characters of a value 4
Show me your highest mileage HDD? 0
Connecting 2 tables, use Query or single field or double field joi 2
Date Query 1

Back
Top