tab control - restricting users from access

[BPBP]

I have a tab control with about 5 pages(or tabs).

I would like to restrict users from accessing 1 of the page. How can i do this?

 

[speakers_86]

Just make the tab hidden. You could do

on open
if "Your Condition Here" Then
me!TabName.hidden=true
End If

That should work. If not, just let me know.

 

[BPBP]

Right now i've not set up any access security. i read somewhere i can set access levels with the in-built security functions? Could this be used for my case?

And how do i refer to the name of the user group that has logged in?

 

[BPBP]

Right now i've not set up any access security. i read somewhere i can set access levels with the in-built security functions? Could this be used for my case?

And how do i refer to the name of the user group that has logged in?

After a search on access security and briefly looking at some of the other posts by the gurus here, i think i should give that a miss. too dangerous for my understanding at this moment.

Now i'm thinking of using custom login forms at the start of the db. when the user logs in, his name/user level will go into a table. When the logged in user clicks the page of the tab control. The on click event will check the username field & compare to a access level table to see if access level is there, if user does not have the required access level, it will prompt msg and setfocus back to 1st tab.

Is this idea workable?

I only have 2 levels, 1 admin level, and 1 user level. The admin level can access all(5) pages of the tab control, but the user level can only access 2 pages.
There is a problem i foresee with this if the admin logs in, follow by user, the access would be at level?

 

[BPBP]

i went ahead and used access security anyway...its working now
but... a few questions:
1) I noticed something... Is it true that only by being a member of "admins" group will I be add/delete users/groups?

2) If i want to disable a certain user's ability to change access levels/permission, which place to set it? (that user will have all permissions to design on forms/tables/etc..., just not able to edit any user level security setting)

3) I did not do splitting of the FE and BE part. Everyone shares the same mdb file in a server. I have about 6 users and the most 3 would be using it at the same time. Making any design changes will only be done after office hours where noone else is logged in. What are the potential problems that may occur with this?

Thanks!

 

[speakers_86]

I am using A07, which does not have ULS (user level security). I can't really help you.