Brad Marks
bradm at blackforestltd.com
Wed May 28 15:36:34 CDT 2014
Jim, 1. I have run many tests while experimenting with the Task Scheduler options. The "Elevated Privileges" option sounded promising, but it did not seem to make any difference. 2. You are right, there are several things to keep in mind when running Access in logged off mode. We have been doing this for a long time and over all it has worked very well. I work for a small firm with a very limited budget. Access has been great for reports and inquiries (both on demand and scheduled) and the cost is very low compared to the alternatives. Our nightly jobs all use UNCs instead of drive mappings. The programs have no need for user interaction. All messages and error logic uses sequential log files. I hope that we can find a way to make this all work with the Windows Server Task Scheduler. It is my understanding that there are third party Job Schedulers available for less than $100. Thanks for your ideas. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Wednesday, May 28, 2014 3:26 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can a "Scheduled" Access application run under Windows Server 2012 in "Logged Off" Mode? Couple of thoughts: 1. Your running afoul of UAC - Make sure you check the box "run with elevated privileges" (or some such - don't remember what it is off-hand at the moment). 2. Keep in mind that when your in a logged off state, there is no user desktop, drives may not be mapped, etc. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, May 28, 2014 04:04 PM To: Access Developers discussion and problem solving Subject: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com