Take it out of access and place it as a vbscript file which can then be scheduled as a when needed to run.
Danny Never Think Impossible If you find my answer helpful then please add to my reputation
Forum Rules