Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

desktop shortcut to access with command-line options

Discussion in 'Information Technology' started by jalewis999, Jul 28, 2006.

  1. jalewis999

    jalewis999
    Expand Collapse
    Guest

    Is it possible to open Access using a desktop shortcut and put command-line
    options in. I've tried but it rejects anthing after the .EXE
     
  2. Loading...

    Similar Threads Forum Date
    Search Gurbani Desktop Version 2.5 Sikh Sikhi Sikhism Aug 14, 2011
    Search Gurbani Desktop Version Sukhmani Sahib Apr 10, 2008
    Gurus Download Desktop Nanakshahi Calendar!! History of Sikhism Nov 5, 2006

  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    If you plan to use command line options, then can't have the shortcut point
    to the mdb (or mde) file, but must have the shortcut point to msaccess.exe
    (the executable), and then *supply* both the mdb file name, and the command
    line switches.

    the following gives an example for a2003.

    note that teach line below is actually on the SAME line in the shortcut you
    create, but each new line would actually be a space.

    "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
    "c:\program files\RidesXP\RidesXP.mdb"
    /wrkgrp "c:\Program Files\RidesXP\Rides.mdw"
    /User "RidesAdmin" /pwd "mypassword"

    Note how quotes go around each file/path name, since they have spaces.....


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  4. Rob Parker

    Rob Parker
    Expand Collapse
    Guest

    Perfectly possible, and the standard method of running secured Access
    applications. For example, I've got a shortcut as follows:

    "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Documents and
    Settings\Rob\My Documents\Rob Work\FSFT\FSFT.mdb" /WRKGRP "C:\Documents and
    Settings\Rob\My Documents\Rob Work\FSFT\FSFT_WRKGRP.mdw" /excl

    That opens my FSFT.mdb application in Access, using the FSFT_WRKGRP.mdw
    workgroup file, in exclusive mode (so I can make design changes). I have
    another shortcut without the /excl switch, to run the application normally.

    If you've got any spaces in your path, you MUST enclose each pathname in
    quotes. Perhaps that's your problem?

    HTH,

    Rob


    "jalewis999" <jalewis999@discussions.microsoft.com> wrote in message
    news:4655B9FA-3EE9-4F92-9A6B-1B59FD26C07E@microsoft.com...
    > Is it possible to open Access using a desktop shortcut and put
    > command-line
    > options in. I've tried but it rejects anthing after the .EXE
    >
     
  5. jalewis999

    jalewis999
    Expand Collapse
    Guest

    Thanks to both of you.
    My problem was I put quotes around the whole thing then inner quotes around
    the paths.

    "Rob Parker" wrote:

    > Perfectly possible, and the standard method of running secured Access
    > applications. For example, I've got a shortcut as follows:
    >
    > "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Documents and
    > Settings\Rob\My Documents\Rob Work\FSFT\FSFT.mdb" /WRKGRP "C:\Documents and
    > Settings\Rob\My Documents\Rob Work\FSFT\FSFT_WRKGRP.mdw" /excl
    >
    > That opens my FSFT.mdb application in Access, using the FSFT_WRKGRP.mdw
    > workgroup file, in exclusive mode (so I can make design changes). I have
    > another shortcut without the /excl switch, to run the application normally.
    >
    > If you've got any spaces in your path, you MUST enclose each pathname in
    > quotes. Perhaps that's your problem?
    >
    > HTH,
    >
    > Rob
    >
    >
    > "jalewis999" <jalewis999@discussions.microsoft.com> wrote in message
    > news:4655B9FA-3EE9-4F92-9A6B-1B59FD26C07E@microsoft.com...
    > > Is it possible to open Access using a desktop shortcut and put
    > > command-line
    > > options in. I've tried but it rejects anthing after the .EXE
    > >

    >
    >
    >
     

Share This Page