Different User, Different Button availability

[UnknownJoe]

Is it possible within a DB to only allow certain buttons to be visble or
active for certain users?
I'm assuming this would all have to be Username and Password related.

Thanks.

 

[Jeff Boyce]

Yes.

One way would be to based it on security implemented via Access security.

Another would be useful if you're working on a netword with network logons.

Which is more suitable in your situation?

Regards

Jeff Boyce
Microsoft Access MVP

 

[Gina Whipp]

UnknownJoe,

Yes...

You assume correctly but I would add... UserName, Password, ShowButtons
(Yes/No). The way you could update a table and not have to *hard code*
UserName and/or Password.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dorian]

Yes, you can do that.
You can identify the user using function fosUsername (google it).
Then you can set the visible property to true or false depending on the user.
This can be done in the form load event.
Normally this would be table driven, you define all your users in a table
and for each have additional column indicating their capabilities.
For instance, I have several applications that allow certain users to make
updates and certain users to be read-only.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".