Best Practices w Security - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Best Practices w Security

John Davy

5 years ago

Hi Rick,
I created a Menu Template which is preceded by a Login Forms which also record who logs in, when etc. as well as when the user logs out. I also created a Groups for my UserT. (My way of learning the content from your videos) Now the question: How about a video that uses the Groups to show us the best way to set up the types of Groups, best and easiest way to control which buttons, forms etc that the users may see but also what they can do on each form. I counted 12 buttons on my Main Menu including a Reports btn, Mainenance btn, Administrative Bt. Is there a better way to control users other than coding every last button, form etc?
Thanks
John Davy

	Alex Hedley @Reply 5 years ago
Access Security Seminars

Scott Axton @Reply

5 years ago

I agree with Alex.  The Access Security Seminar is the base answer.

In answer to your last question, "... coding every last button, form, etc?"

Yeah - you pretty much have to do the behind the scenes work to get the front end results.  Unfortunately, Access doesn't have a 'mind reader mode' where it knows what you want instead of what you programed it to do.
Goodness knows I would use that a lot if they came out with it!

One thing you might consider is grouping your buttons into a different form for certain privileges.  Check to see if the user can access that form and if they do they have access to all the buttons on that form.

	Adam Schwanz @Reply 5 years ago
Yea you kinda have to give it everything it needs. Grouping is one option. You can also use something like this for your "admin" group that gets everything turned on Dim X as Control For Each X In Me X.Visible = True Next

	Richard Rost @Reply 5 years ago
Yeah, I wouldn't code every last button, but definitely set up separate menus (forms) for the groups that need them. Then you only have to put code in one button to get to that whole menu.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View