James Button
jamesbutton at blueyonder.co.uk
Mon Mar 11 07:21:26 CDT 2013
Yep, probably better to set the path to the data folder, and use path on the .exe and - as you indicate you can specify the database to be opened, maybe even pass on a script name to run the appropriate application - might need to bound that in double ""qoutations"" Re the EXE - I add MSWORD, NOTEPAD and WORDPAD to the SEND-TO folder for users which is where I came across the problem with a .EXE that isn't really the application. As I like the ability to specifically name the started window - I never missed out the title, so wouldn't have found out it is a required option! Still being learned! 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 11:58 PM 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