can user's login result in different switchboards

[Chris v.]

Please advise me if this is not the best way to accomplish the desired
result. I am new to Access and have very limited programming experience. I'm
creating a split database. There will be several users with different
permissions to use the database: 1) View ONLY, 2) Edit some tables through
forms, 3) Edit all tables through forms and 4) Administrator (Full Access). I
would like the users to log on the the database as the agency only uses a
file server (this will hold the back-end, and I will install the front-end
along with Access runtime on the local boxes). I'm thinking that there could
be a switchboard for each permission level, which would load after a log-in
form is completed. The different switchboards would all be copies of the main
switchboard, but with comand buttons disabled (and grayed) per users access
to the database. So I have 2 questions: 1) Is this a workable plan and 2) How
do I load the correct Switchboard once log-in is completed? I've only used
macro's so far.

 

[KARL DEWEY]

You will need to search on how to read the user but you could have it as a
condition in a macro to set the visible properties of the buttons to No.

Then On Close of the switchboard form set the property back.