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


"John V" wrote:

> 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