Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Unanswered: Launching an Access db with a specific MDW ...

    Hi all.

    I saw this question posted before ... (I know, I know - Search ...) But, since the search no longer works I'm posting this question I saw before ...

    What is the switch setting to use on say a shortcut to run an access DB with a specific MDW file?

    Thanks.
    Back to Access ... ADO is not the way to go for speed ...

  2. #2
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    Quote Originally Posted by M Owen
    Hi all.

    I saw this question posted before ... (I know, I know - Search ...) But, since the search no longer works I'm posting this question I saw before ...

    What is the switch setting to use on say a shortcut to run an access DB with a specific MDW file?

    Thanks.
    That would be
    Call Shell("C:\Program Files\Microsoft Office\Office10\msaccess.exe C:\path\dbname.mdb", 1)
    bhummel

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by bhummel
    That would be
    Call Shell("C:\Program Files\Microsoft Office\Office10\msaccess.exe C:\path\dbname.mdb", 1)
    bhummel
    Not quite what I was asking for ... That's what you do to invoke from within an access db ... I'm talking about the shortcut on the desktop.
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    "C:\Program Files\Microsoft Office\Office10\msaccess.exe \\server\folder\DataBase.mdb /wrkgrp \\Server\Folder\WorkGroup.mdw"
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pootle flump
    Hi

    "C:\Program Files\Microsoft Office\Office10\msaccess.exe \\server\folder\DataBase.mdb /wrkgrp \\Server\Folder\WorkGroup.mdw"
    BINGO! Thanks.
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Well ... Almost. the /wrkgrp pathname\accessdb.mdw doesn't work in a shortcut ...

    Hmmmm ....
    Back to Access ... ADO is not the way to go for speed ...

  7. #7
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I have it for you MOwen ...

    The Target:

    "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Documents and Settings\The Vortex\My Documents\CT Industries\ctrim.mdb" /WRKGRP "C:\Documents and Settings\The Vortex\My Documents\CT Industries\Secured.mdw"

    Start In:

    "C:\Documents and Settings\The Vortex\My Documents\CT Industries"

    Hope this helps some.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  8. #8
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Let me know if that works... It has worked for me on Windows 98, ME, XP Pro, and XP Home.

    I hope it helps ya,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  9. #9
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by JSThePatriot
    Let me know if that works... It has worked for me on Windows 98, ME, XP Pro, and XP Home.

    I hope it helps ya,
    JS
    Yep. Did the trick ... And jogged the ol memory ... NOW, I remember doing this same thing a few years ago ... I just forgot that little detail of windows using associations to launch shortcuts ... So I needed the explicit call to msaccess in there ...

    Thanks JS
    Back to Access ... ADO is not the way to go for speed ...

  10. #10
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Not a problem at all glad to be of service.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •