Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303

    Unanswered: Open DB with username and password from DOS?

    I have run batch files like this...

    c:
    cd\C:\Program Files\Microsoft Office\Office
    MSACCESS C:\myFolder\myPath\myGoodness\MyDB.mdb /Wrkgrp "C:\myFolder\system.mdw"

    line 1 moves to the drive I want
    line 2 goes to the path where access is
    line 3 opens Access in 3 parts: a)Access is started, b)the database I want is specified, c) the parameter /Wrkgrp will reference the username/password stuff

    This will open the dialogue box for the user to enter name/password.


    Question for DOS batch gurus. Is there a way to send the username and password from the batch file?


    John
    This is the day the Lord has made, I will rejoice and be glad in it.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    yes, there is. user the /user and /pwd command line switches

    MSACCESS C:\myFolder\myPath\myGoodness\MyDB.mdb /Wrkgrp "C:\myFolder\system.mdw" /user IAmTheBoss /pwd TopSecret

Posting Permissions

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