Trying to implement security - doesn't prompt for userID

[ajaeger]

This is my first crack at implementing user IDs in Access. I must be doing something wrong...

I have set-up myself as a user, user name is 'Anna', under Tools>>Security>>User and Group Accounts. I am a member of the Admins and Users groups. The default Admin user is set-up the same.

When I go to the Change Login Password tab, it always defaults to the Admin user. How do I set-up a password for user 'Anna'?

How do I change the password for user 'Admin'? I assumed the Old Password was blank, and I tried to enter a New Password and Verify it, but I get the message that "The Password you Entered in the Old Password box is incorrect."

Once I get this set-up, how do I get Access to prompt me for a user name/password upon login?

Thanks.

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[Blorf]

Hi.

There are a million web pages out there to help with this, but the crux of your problem I think is that although you are telling your work group to require a password, the same default work group on any other pc will let you in.

Take a peek at

http://www.databasedev.co.uk/access_security.html,

it has step by step instructions, and there are some good faq's to be found here.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.