User Permissions

[Guest]

I have been working on creating a database for work. I have all the
designstuff done that I wanted. Now I am trying to set the security features.
I have created the User groups, users, and set the permissions. However when
I set the Admin password my database had a hissyfit. However when I removed
the Admin password the login popup disappeared? How can I get the login back
and set passwords for each user? Or can I?

 

[Lynn Trapp]

It would be helpful if you would tell us what kind of "hissyfit" the
database is having. have you read the Security FAQ? If not, you need to
start over there. You can find a link to it on the security page of my
website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Joan Wild]

I hope that you have followed the necessary steps to secure your database.
You don't just go into the security menu and start adding users/groups.

Setting a password for the Admin user is what causes the login dialog to
appear. Please explain what you mean by 'database had a hissyfit'.

You need to set a password for the Admin user to get the login back.

Start your database using the secure workgroup file you created (you did
this, right?). You'll get no login, but you'll be using the correct
workgroup file. Go to Tools, Security, Accounts and click on Change
Password tab - set a password for this user (which should be Admin).

 

[Guest]

the hissyfit was things stopped working. I was nolonger able to run any
macros, my switchboard died nothingon it would work anymore. So I had to use
the backup I created before adding the Admin password.

 

[Joan Wild]

Do you mean you got 'no permission' errors? If so then you're not logging
in as the correct user, or you need to adjust the permissions.

 

[Guest]

It is working correctly now with the users logging in, butI have another
issue.

I want to be able to set permissions so that only certian users can access
certain items on the switchboard. There is only one item on the switchboard
that I don't want everyone to access. This item should only be access by
Accounting and Database Admin. However right now everyone can access it. How
can I change that?

Cheers

May

 

[Joan Wild]

The switchboard manager is limiting and difficult to work with in my
opinion.

I usually create an unbound form and just add all the buttons/controls I
need.

Using this method, I can hide buttons depending on the current user's group
membership.

I would think that in your case, other folks might be able to click the
button, but they shouldn't get far - i.e. they don't have permission to open
that form, so does it matter?

 

[Guest]

Thanks for all your help

 

[Guest]

Joan, can you elaborate? How can you hide objects by user group?

Thx,
Michelle

 

[Joan Wild]

Assuming you have your own switchboard type form for navigation, and you're
using the faq_IsUserInGroup() function from the security FAQ
http://support.microsoft.com/?id=207793


If faq_IsUserInGroup("Managers",CurrentUser()) = True Then
Me!cmdFixUp.Visible = True
Me!cmdSuperReports.Visible = True
Me!cmdViewArchive.Visible = True
End If

You can modify this for other groups; you need to plan it well since users
can be members of more than one group. I generally plant security to ensure
that a user is a member of only one group.