User2 only can view/browse the form and report

[hfsitumo2001]

Below is my Log in Table. The AccessType, I have Admin, User, User2.
How can we make it that User2 can only View/browse reports of forms.

 

[arnelgp]

you don't give access to anyone (except you), to the navigation pane.
you create different "Ribbon Menu" or switchboard for each "AccessType"

 

[hfsitumo2001]

you don't give access to anyone (except you), to the navigation pane.
you create different "Ribbon Menu" or switchboard for each "AccessType"

In the main switchboard, we create another switchboard?

 

[arnelgp]

here is a sample again.
use user: admin, password: 1234

it will open switchboard.
see the "User Table" is in the menu.
choose "Exit program" to close the db.

re-open the db.
use User:common, password: common
the "User Table" menu is not available.

the idea is copy the "switchboard items" to new table (switchbord items2).
and copy the switchboard to switchboard2.

edit switchboard2 form (all its macros) and change the dlookupto point to "switchboard items2".

 

[hfsitumo2001]

here is a sample again.
use user: admin, password: 1234

it will open switchboard.
see the "User Table" is in the menu.
choose "Exit program" to close the db.

re-open the db.
use User:common, password: common
the "User Table" menu is not available.

the idea is copy the "switchboard items" to new table (switchbord items2).
and copy the switchboard to switchboard2.

edit switchboard2 form (all its macros) and change the dlookupto point to "switchboard items2".

Thank you Arnel, I will study first.

 

[arnelgp]

here is another sample and i think more
appropriate of what you need.

same users and password.
form user admin, it is unrestricted access.

for user, common.
he/she can open the customer form for viewing.
while the Use form is not accessible.

open the db with common user first
to see what i mean.

 

[Pat Hartman]

Here's an example using a custom switchboard. You can use the standard Access switchboard if you want by just adding a couple of extra fields but you will need to create a maintenance form for yourself or you'll be maintaining the table directly.

 

[hfsitumo2001]

Here's an example using a custom switchboard. You can use the standard Access switchboard if you want by just adding a couple of extra fields but you will need to create a maintenance form for yourself or you'll be maintaining the table directly.

Thank you Pat, I will try to understand first