Assigning User Passwords

[Guest]

I think I have read all of the suggested articles regarding Access security
setups, but I still do not understand (after setting up a Workgroup Info
File, Groups, and Users) where you go to enter passwords for the newly
created users. My mdb file willl be residing on a company intranet server.

Linus

 

[Joan Wild]

If you implement security manually, you log in as the user and go to Tools,
security, accounts...Change Password tab and set a password.

If you use the security wizard (2002/2003), you can set the passwords as you
create each user.

 

[Guest]

Thanks, Joan, for your quick response. I need "baby steps," I guess...

I have used the "User-Level Security Wizard," but after entering a user and
then going to the "Password" tab, I see "Admin" as the user name in the upper
left corner. LPerhaps, I'm so ignorant about all of this, that I'm missing
something more basic, i.e, do I need to setup new user accounts in Windows XP?

Linus

 

[Guest]

Additional info...I cannot even gain access to the DB by using the wizard
default settings...I must deselect all objects, etc. on the wizard's 2nd
screen, then allow users permissions on the 3rd screen. You are correct in
that on the 4th screen, you can add users and their passwords (my memory of
this was lost since I gave up the wizard and have been using the manual
method of using "Tools\Security\User & Group Accounts, etc.) However, after
using the wizard; exiting Access; re-opening Access and then clicking on my
db to open it, I'm only prompted for a password. How do I get it to prompt
me for a user name and a password?

Also, note that after using the wizard and going the "manual" route to tweak
the "Users, Groups, etc." that users I setup in the wizard are not seen in
the "Users & Groups" tab. It appears these two programs do not write to the
same WID. Terminology in both of these pgms is also different, lending to
further confusion.

 

[Joan Wild]

However, after
using the wizard; exiting Access; re-opening Access and then clicking on
my
db to open it, I'm only prompted for a password. How do I get it to
prompt
me for a user name and a password?

You are opening Access using the workgroup that is set as your default.
This is/or should be/ the standard system.mdw that ships with Access. The
wizard would have created a desktop shortcut for you. Use that to start
your secure mdb, as it will over-ride the default mdw and use your secure
mdw.

Also, note that after using the wizard and going the "manual" route to
tweak
the "Users, Groups, etc." that users I setup in the wizard are not seen in
the "Users & Groups" tab. It appears these two programs do not write to
the
same WID. Terminology in both of these pgms is also different, lending to
further confusion.

What you are doing is setting up users/groups in the standard system.mdw
that ships with Access. You definitely do not want to do that. You want to
be using your secure mdw. Again, use the desktop shortcut to start your
secure mdb. Then you can go into the security dialogs to tweak the
users/groups. Undo what you did to the system.mdw, as it is used for all
unsecure databases.

 

[Guest]

Thank you, Joan, for your assistance. With your help, I have succeeded in
getting over a very frustrating process.

Linus