Access 2003 Package Wizard Passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Did you also copy the appropriate MDW to the other machine, and does your
shortcut also include the /wrkgrp option pointing to that MDW?
 
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
 
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.
 
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...
 
Back
Top