Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Angry Unanswered: Command Line from bat file

    Hi everyone,

    I'm having a serious brain lapse here! I'm trying to call a macro from a bat file and can get the mdb file open but the macro won't run. I know it is something simple like a -x or something but I can't remember. Any help or thoughts would be appreciated.

    Thanx, Stu

    C:\temsdb\StandardDataFeedTables.mdb -x mcrBatTest

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    x it is but /x

    however you do need to specify the path to Access as part of the bat file.....
    http://support.microsoft.com/kb/209207 (wonderful thing Google)

    from the reference.... thats going to be something similar to...
    "C:\Program Files\Microsoft Office\Office10\msaccess.exe" "C:\temsdb\StandardDataFeedTables.mdb" -x mcrBatTest

    ..assuming that you are using Access V10 and it was located in "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Thank You

    Thanks! I had tried MSN looking for that very page but couldn't find the 'switches'. I tried 'command line', 'opening parameters', but to no avail! What would we do w/out Google!

    Thanks again!

    PS: Worked like a charm once I had my quotes in the right spot!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I used
    MS Access command line switches
    as the google terms........
    and it found 557,000+ hits of which the first one was the cited ref....
    http://www.google.co.uk/search?clien...=Google+Search.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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