Jim Lawrence
accessd at shaw.ca
Thu May 29 11:47:29 CDT 2014
Hi Brad: "running into some sort of authorization issue" would be my guess too. I have found the running a scheduled program can be a two stepper...one; the actual application creates the data and two; the scheduled batch process, independently, in administration mode, processes the batch. Running as a user or as multiple users can go off the rails very quickly. For some applications I had the program create various flag files in a common area which would tell these two separate entities when to process and avoid conflicts. Jim ----- Original Message ----- From: "Brad Marks" <bradm at blackforestltd.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, May 29, 2014 9:28:38 AM Subject: Re: [AccessD] Can a "Scheduled" Access application run under Windows Server 2012 in "Logged Off" Mode? Jim, Thanks for the link. I am trying to get up to speed with the Windows Server 2012 Task Scheduler and all of its new features. I have tried to run a test Access application both directly from the Scheduler (MSACCESS.EXE) and initiated via a small script. In both cases, the Access application will run nicely when logged on, but will not run nicely when logged off. I have set the Scheduler setting to "Run While Either Logged On or Logged Off". Based on the tests that I have run and from what I have read on various internet forums, I believe that I am either running into some sort of authorization issue or Microsoft has made a change to prevent Access from running in logged off mode. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Thursday, May 29, 2014 11:09 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: Can I assume that you have run a command line batch file called from your application? http://technet.microsoft.com/en-us/library/cc748993.aspx Jim ----- Original Message ----- From: "Brad Marks" <bradm at blackforestltd.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, May 29, 2014 5:04:40 AM Subject: Re: [AccessD] Can a "Scheduled" Access application run under Windows Server 2012 in "Logged Off" Mode? Jim, Thanks for the advice. I thought that I was running into a problem with how the Windows Server 2012 Task Scheduler works. Based on your post, it sounds like the problem is related to Access running in "logged off" mode, no matter how the job is scheduled. Brad ________________________________________ From: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> on behalf of Jim Dettman <jimdettman at verizon.net> Sent: Thursday, May 29, 2014 5:54 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? <<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.>> I don't think you will. I had issues moving to 2008, explored a half dozen 3rd party schedulers, even wrote my own in Access, all with the same results. I ended up running everything as a foreground app with a user being constantly logged in. One interesting thing I found there; Application.Quit would often cause a hang where DoCmd.Quit would not. 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:37 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? 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 -- 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com