Disable a control button for certain users

[Guest]

I've created a control button on my main form, but need to only allow certain
users access to this button. Is there some way I can disable the control
button for certain users, but still have it enabled for others? I have tried
using the Visible property, but can't seem to get it to work (I'm fairly new
to creating Access databases). Any suggestions or other references would be
greatly appreciated!

 

[Lynn Trapp]

Kat,
You will have to either implement Access User Level Security (see Security
FAQ via link on the Security page of my website) or, else, create your own
means of having users log on. Once you have implemented Security, then you
can use the CurrentUser function to do set the visible property of your
button.

--
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

 

[M Skabialka]

Or you can create a table of users, based on their computer logon name, and
give them a level.
Check the user name when they open the form (or database) and show or
disable the control based on their level.
To get their logon name use: Environ("username")

Mich

 

[Guest]

Thanks! This got me pointed in the right direction!

 

[M Skabialka]

I've always hated the Access User Level Security methods. I am much more in
control with this concept.