Welcome to SPN

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

Sign Up Now!

Access 2003 Package Wizard Passwords

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

  1. jimtotem

    jimtotem
    Expand Collapse
    Guest

    I selected "/user" (User Name) and "/pwd" (Password) options when running the
    Package Wizard for my Access database application. I also selected Access
    Runtime.
    After installing onto my other computer, I received an error message
    indicating that the User Id and/or Password were incorrect. I know that they
    were correct!
    Could someone straighten me out? Thanks in advance.
    Jim
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Did you also copy the appropriate MDW to the other machine, and does your
    shortcut also include the /wrkgrp option pointing to that MDW?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "jimtotem" <jimtotem@discussions.microsoft.com> wrote in message
    news:6E5F790F-E081-4170-95B8-0C5A1686CB66@microsoft.com...
    >I selected "/user" (User Name) and "/pwd" (Password) options when running
    >the
    > Package Wizard for my Access database application. I also selected Access
    > Runtime.
    > After installing onto my other computer, I received an error message
    > indicating that the User Id and/or Password were incorrect. I know that
    > they
    > were correct!
    > Could someone straighten me out? Thanks in advance.
    > Jim
    >
     
  4. jimtotem

    jimtotem
    Expand Collapse
    Guest

    No, I did not include the MDW file in the package. Since I do not know the
    name and location of the other user's Workgroup, how can I assure that it
    will be installed properly?

    Jim


    "Douglas J. Steele" wrote:

    > Did you also copy the appropriate MDW to the other machine, and does your
    > shortcut also include the /wrkgrp option pointing to that MDW?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "jimtotem" <jimtotem@discussions.microsoft.com> wrote in message
    > news:6E5F790F-E081-4170-95B8-0C5A1686CB66@microsoft.com...
    > >I selected "/user" (User Name) and "/pwd" (Password) options when running
    > >the
    > > Package Wizard for my Access database application. I also selected Access
    > > Runtime.
    > > After installing onto my other computer, I received an error message
    > > indicating that the User Id and/or Password were incorrect. I know that
    > > they
    > > were correct!
    > > Could someone straighten me out? Thanks in advance.
    > > Jim
    > >

    >
    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    If your application requires a user name and password to use it, the user
    information is stored in the MDW file. You must distribute the MDW file that
    you created when securing the database along with your MDB or MDE file.
    Since you're distributing it, you control where it goes...

    Your MDW file definitely should not replace their existing MDW file, since
    that would then impact all their other databases.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "jimtotem" <jimtotem@discussions.microsoft.com> wrote in message
    news:2B36EBDC-336C-4412-B62D-3666F25382A8@microsoft.com...
    > No, I did not include the MDW file in the package. Since I do not know
    > the
    > name and location of the other user's Workgroup, how can I assure that it
    > will be installed properly?
    >
    > Jim
    >
    >
    > "Douglas J. Steele" wrote:
    >
    >> Did you also copy the appropriate MDW to the other machine, and does your
    >> shortcut also include the /wrkgrp option pointing to that MDW?
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no private e-mails, please)
    >>
    >>
    >> "jimtotem" <jimtotem@discussions.microsoft.com> wrote in message
    >> news:6E5F790F-E081-4170-95B8-0C5A1686CB66@microsoft.com...
    >> >I selected "/user" (User Name) and "/pwd" (Password) options when
    >> >running
    >> >the
    >> > Package Wizard for my Access database application. I also selected
    >> > Access
    >> > Runtime.
    >> > After installing onto my other computer, I received an error message
    >> > indicating that the User Id and/or Password were incorrect. I know
    >> > that
    >> > they
    >> > were correct!
    >> > Could someone straighten me out? Thanks in advance.
    >> > Jim
    >> >

    >>
    >>
    >>
     
  6. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Just one more issue:

    Do you now use the workgroup, and have setup passwords and users for
    ms-access?

    Those user name + password you set in the command line options don't
    actually set, nor create a user or password, but simply set the DEFAULT user
    and password you *WANT* to use. However, you would still have to create
    these users, and setup the user in the workgroup file your self...use of
    those command line switches does not do this, nor create a user for you.

    Thus, it follows, if you did setup and create that user you specified in the
    command line options, then you must obviously then include your own
    workgroup file and have setup security. If you not using passwords, and
    workgroup security now..then don't use those command line switches at all...


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

Share This Page