run query daily at a specified time

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
 
J

John W. Vinson

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]
 
G

gls858

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
 
Top