[AccessD] How do you change the priority permanently forMsAccess

DJK (John) Robinson djkr at msn.com
Sun Mar 10 18:58:12 CDT 2013


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




More information about the AccessD mailing list