Bill Patten
bill_Patten at earthlink.net
Thu Aug 10 12:54:33 CDT 2006
I don't know about the no password, it seems that if it is empty and works for other things it should work but .... You can test it by right clicking and then run so you don't have to mess with the time thing. You might try right clicking on it, going to properties and entering System in the run as and try that. I did that on a test running a test batch file, and the name was changed to NT AUTHORITY\SYSTEM and see if that works. Bill ----- Original Message ----- From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, August 10, 2006 9:46 AM Subject: Re: [AccessD] Trigger code every day Bill: Never used Windows Scheduler before but it looked pretty simple so I set up a task and pointed to the mdb and set the time for two minutes later than the current clock. But it didn't run because I didn't specify a user account password. But there is no password for this machine. Just the default account 'HAL9004\Rocky' but I don't have a password. Do I need to set a password in order to use the scheduler? Thanks and regards, Rocky Bill Patten wrote: > Hi Rocky, > > With out knowing all the details, I'd be tempted to use Windows Schedule > tasks and let it do the work. You can pick times days etc. > > HTH > > Bill > ----- Original Message ----- > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Thursday, August 10, 2006 9:09 AM > Subject: [AccessD] Trigger code every day > > > Dear List: > > A client needs to run a program every day at the same time to export > some files. I'm thinking that I use the OnTimer event with some timer > interval (like 5 minutes) and check the clock to see if it's time to do > the export. This app will run all the time in the background and reside > probably on their server. Is this going to suck up a lot of server > cycles? Is there a better way to do this? > > MTIA > > Rocky > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com