Automate a query to run on a certain day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an update query which needs to be run on a certain day of the month
each and every month. The problem I have is that access is not continually
open and there are times that I am off work and do not have remote access
from home to run the query. The computer that I work off of is a shared
computer, and the database is on a server. Is there a way to somehow have
this query run?

Thanks
 
Hi John

I would create a macro that runs the query and exits Access.
Then use the Windows scheduler with the following command line...

"full path and file of MSACCESS.EXE" "full path and file of .MDB" /X "macro
name"

Regards

Andy Hull
 
Back
Top