Brad Marks
bradm at blackforestltd.com
Thu May 29 06:59:48 CDT 2014
Gustav, >> I wonder how you did this in W2003 I guess that I was just naive. I wrote an Access application to pull data from several data sources and then create reports (PDF format) from this data. There is no "user interaction". Error handling is set up to write records to a sequential log file (had very few errors in 5 years). I then placed the Access application on a Windows Server 2003 machine and used the Windows Scheduler to run it every night. Because this application has worked so well, I was surprised when I ran into problems with the Windows Server 2012 Task Scheduler. Thanks for your advice. Brad ________________________________________ From: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> on behalf of Gustav Brock <gustav at cactus.dk> Sent: Thursday, May 29, 2014 3:46 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Can a "Scheduled" Access application run under Windows Server 2012 in “Logged Off” Mode? Hi Brad I wonder how you did this in W2003. To my best knowledge you can't run a desktop app without a logon. Even if you should succeed, W2012 (R2) is not intended for this purpose. Create a Hyper-V virtual machine running Windows 8.1 (fastest) or another desktop OS. Configure this to always start and, when started, to autologon to a restricted user account. /gustav ________________________________________ Fra: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> på vegne af Brad Marks <bradm at blackforestltd.com> Sendt: 28. maj 2014 22:03 Til: Access Developers discussion and problem solving Emne: [AccessD] Can a "Scheduled" Access application run under Windows Server 2012 in “Logged Off” Mode? All, Earlier, I posted a question that involved a script initiating an Access application. After doing a fair amount of experimenting, I believe that this problem has nothing to do with the script. I think that it all boils down to whether it is possible to run an Access application in “Logged Off” mode under Windows Server 2012 R2. I have a number of automated report jobs that pull data from SQL Server, Pervasive, and Firebird databases to create reports every night. These jobs have worked nicely for over five years while running on an old server with Windows Server 2003. Now, with the upgrade to new hardware and Windows Server 2012, I cannot get any Access application to run in logged off mode via the Task Scheduler. Has anyone been able to do this? Have others run into this same problem? We are migrating from Windows Server 2003 to 2012. I would guess that 2008 and 2011 are similar to 2012. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com