Home All Groups Group Topic Archive Search About

Shorcut with pointing to two ACCESS.EXE

Author
7 Sep 2006 7:47 PM
erick-flores
Hello all

I am having a lil problem here. Is there a way to create just ONE
shorcut that points to two (2) different folders where the ACCESS.EXE
is located?

e.g. "C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE"
"\\Hou0602\Intranet\Expense Report Interface\Expense Report Interface
..MDB" /WRKGRP "\\Hou0602\Intranet\Expense Report
Interface\Security.mdw"

BUT what if the MSACCESS.EXE is locates under the folder C:Program
Files\Microsoft Office\OFFICE11\MSACCESS.EXE...can I mix both with just
one shorcut, so I dont need to save the shorcut and then change the
properties of the shorcut in order to point to a different folder?

Thanks...

Author
8 Sep 2006 12:20 AM
Joan Wild
No you can't.

--
Joan Wild
Microsoft Access MVP

erick-flores wrote:
Show quoteHide quote
> Hello all
>
> I am having a lil problem here. Is there a way to create just ONE
> shorcut that points to two (2) different folders where the ACCESS.EXE
> is located?
>
> e.g. "C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE"
> "\\Hou0602\Intranet\Expense Report Interface\Expense Report Interface
> .MDB" /WRKGRP "\\Hou0602\Intranet\Expense Report
> Interface\Security.mdw"
>
> BUT what if the MSACCESS.EXE is locates under the folder C:Program
> Files\Microsoft Office\OFFICE11\MSACCESS.EXE...can I mix both with
> just one shorcut, so I dont need to save the shorcut and then change
> the properties of the shorcut in order to point to a different folder?
>
> Thanks...
Author
13 Sep 2006 4:38 PM
Andrew Tapp
You could try creating a batch file and testing the various folders e.g.

IF EXIST "C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE"
GOTO ONE

IF EXIST "C:Program
Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
GOTO TWO

GOTO EXIT

:ONE
"C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE"
"\\Hou0602\Intranet\Expense Report Interface\Expense Report Interface
...MDB" /WRKGRP "\\Hou0602\Intranet\Expense Report
Interface\Security.mdw"

GOTO EXIT

:TWO
"C:Program
Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"\\Hou0602\Intranet\Expense Report Interface\Expense Report Interface
...MDB" /WRKGRP "\\Hou0602\Intranet\Expense Report
Interface\Security.mdw"

GOTO EXIT

:EXIT

Hope this helps.

Show quoteHide quote
"erick-flores" wrote:

> Hello all
>
> I am having a lil problem here. Is there a way to create just ONE
> shorcut that points to two (2) different folders where the ACCESS.EXE
> is located?
>
> e.g. "C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE"
> "\\Hou0602\Intranet\Expense Report Interface\Expense Report Interface
> ..MDB" /WRKGRP "\\Hou0602\Intranet\Expense Report
> Interface\Security.mdw"
>
> BUT what if the MSACCESS.EXE is locates under the folder C:Program
> Files\Microsoft Office\OFFICE11\MSACCESS.EXE...can I mix both with just
> one shorcut, so I dont need to save the shorcut and then change the
> properties of the shorcut in order to point to a different folder?
>
> Thanks...
>
>