Mark Simms
marksimms at verizon.net
Sun Mar 10 21:15:36 CDT 2013
There are utility programs out there that do this via configuration. Prio is one, Priority Manager is another. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of DJK (John) Robinson > Sent: Sunday, March 10, 2013 7:58 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] How do you change the priority permanently > forMsAccess > > Well, I thought that a .exe was a .exe, if you see what I mean ... > > But it does work, for whatever reason; though I think I'd prefer the > CD if any to be to the database folder, with the > full path to the .exe specified in the START command: > > CD <database folder path> > START /HIGH "<fullpath>\msaccess.exe" <database>.mdb > > > That's on WinXP. Win7Ult64 behaves *almost* the same way (this is > MS!), but you do need the supposedly optional 'title' > operand first, as given by James. Eg: > > CD <database folder path> > START "title" /HIGH "<fullpath>\msaccess.exe" <database>.mdb > > > Ok, Ed? > > John > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of James Button > Sent: 10 March 2013 23:10 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] How do you change the priority permanently > forMsAccess > > > Be careful that you are referencing the actual .exe rather than the > shortcut > that the system sets up. > > go to the partition and folder first (wherever your system has it > installed) > > The following gets me a low priority Access session in XP Pro > > > > C: > CD "\Microsoft Office\Office14\" > START "titl" /LOW MSACCESS.EXE" > > JimB > > ----- Original Message ----- > From: "DJK (John) Robinson" <djkr at msn.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Sunday, March 10, 2013 10:17 PM > Subject: Re: [AccessD] How do you change the priority permanently > forMsAccess > > > > ... I should have added - that was on Win XP, where my email is; > I'll > > check on Win 7 Ult 64-bit later. > > > > John > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DJK (John) > > Robinson > > Sent: 10 March 2013 22:14 > > To: 'Access Developers discussion and problem solving' > > Subject: Re: [AccessD] How do you change the priority permanently > > forMsAccess > > > > > > Well, after a little experimentation, I found ... > > > > In a command window, > > START /HIGH application.EXE > > works just fine for things like notepad and paint, but not, alas for > > Word, > > Excel and Access. So the theory was good, > > but it doesn't work for Ed's purposes. > > > > Anyone got any ideas why, or how to fix it? > > > > John > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James > Button > > Sent: 10 March 2013 19:50 > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] How do you change the priority permanently > > forMsAccess > > > > > > Create a link (sort of a shortcut type file) .cmd file to initiate > > the > > process- > > see the help in > > Start > > run > > cmd > > START /? > > > > JimB > > > > ----- Original Message ----- > > From: "DJK (John) Robinson" <djkr at msn.com> > > To: "'Access Developers discussion and problem solving'" > > <accessd at databaseadvisors.com> > > Sent: Sunday, March 10, 2013 6:30 PM > > Subject: Re: [AccessD] How do you change the priority permanently > > forMsAccess > > > > > >> Hi Ed > >> > >> Sorry I don't know the answer, but it must be possible, as in your > >> observation of Task Manager. Have you tried using the 'DOS' START > >> command? I haven't, but it might be worth investigating. > >> > >> I am curious about one thing in your setup, though. If as I infer > >> your application is not competing with anything for > >> processor time, how much difference does altering the priority make? > >> > >> John > >> > >> > >> -----Original Message----- > >> From: accessd-bounces at databaseadvisors.com > >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward > >> Zuris > >> Sent: 10 March 2013 15:57 > >> To: accessd at databaseadvisors.com > >> Subject: [AccessD] How do you change the priority permanently for > >> MsAccess > >> > >> Question: > >> > >> While using Win7, how do you change the priority permanently for > >> MsAccess.exe ? > >> > >> Notes: > >> > >> I have a dual processor 3.7 gigabyte system using Windows7 Pro > 64bit. > >> > >> This computer's main mission, its only mission, is to run an app > >> written in Access-2003 32bit VBA several times per day quickly. > >> > >> What I have been doing to get the desired performance is do a > >> Ctrl-Control-Delete to start the Program-Manager. > >> > >> Then adjust that msAccess job's priority by hand. > >> > >> I been doing this by hand for the last year. > >> > >> Since I about to turn this over to another person it would most > >> helpful to automate this priority changing process. > >> > >> By the way, I have noticed that when the Program-Manager starts up > >> with it's priority already set to high. > >> > >> Thus that is a big clue such an action is possible. > >> > >> I would like to do the same for MsAccess.exe program launches. > >> > >> Hopeing that there some Databaseadvisors.com knowledge on this > >> subject. > >> > >> Any idea's on how to do that ? > >> > >> Thanks. > >> > >> Sincerely, > >> Ed Zuris. > >> edzedz at comcast.net > >> > >> > >> -- > >> 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