To access (no pun intended) the Access database, you might want to look into Win32::ODBC or one of the DBI modules (I haven't had to use them so I can't be more specific). You can get Win32::ODBC at http://www.roth.net/perl, or from the PPM repository at http://www.roth.net/perl/packages.
As for the second part, what context do you want the script to run under. You can use Win32::Lanman's NetScheduleAdd() function to add scheduler entries that will run under the system context. Keep in mind, of course, that the LocalSystem account cannot access UNC paths, so drives must be mapped under a user context if you're planning on doing anything over a network. I haven't had sufficient time to play with them, but there are two modules specifically for working with the Task Scheduler (NetScheduleAdd uses or simulates the old AT commands). These are Win32::Scheduler, which you can get at the PPM archive above, and there is also one on SourceForge that was working pretty well the last time I saw it. Check out http://sourceforge.net/projects/taskscheduler/. The advantage of these two is that they directly interface with the Task Scheduler and allow you to set the user account under which to run, retrieve exit status, etc. -----Original Message----- From: Dan To: [EMAIL PROTECTED] Sent: 4/7/02 7:31 AM Subject: Microsoft Access/Running program as a service on Win2k Hello all, Is it possible to export an Access query on an Access database to a text file. So what I want to do is connect to an Access database then simply run an SQl query on the database/table. From there I need the results of that query to be exported to a comma delimited text file. Has any one done this before? Also I know I can easily create a perl script that will run as a daemon on a Unix machine, but can I do the same but have my perl script run as a service on a Windows2000 machine? I need a script to run every 24hours without any user interaction? Is this possible ? s I am unfamiliar with what Active Perl/Windows can actually do? Regards, Dan -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -------------------------------------------------------------------------------- This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
