question about security level

[esso121]

hi everyone i have a table user contain iduser, username, pass, usertype and i need to make security level for'data entry' users that not allowed to open tables or some forms i have tried select case in'login form'and didnt work

 

[NauticalGent]

Can you provide some info on your table structure and your Code?

 

[esso121]

table user fields is userid, username, pass, usertype and i put my code in login button of login form and i use select case
case is txtusername = "ess" then forms. application. allow edits= false
forms. application. allow additions =false
end select

 

[vba_php]

table user fields is userid, username, pass, usertype and i put my code in login button of login form and i use select case
case is txtusername = "ess" then forms. application. allow edits= false
forms. application. allow additions =false
end select

just a quick note.....esso, it seems like what you're doing is just fine. users should never be allowed to access tables anyway, which is the purpose of a deliverable, such as an .accde file. then there are other discoveries that can be made which pose a threat to you as a developer. stuff like the SHIFT key bypass option when opening a db. but that's a story for another day. I just wanted to note these things....Gent can help you regarding the problem. He knows more about it than I do anyway.

 

[NauticalGent]

i have tried select case in'login form'and didnt work

At face value your concept and code seem correct, can you be more specific a to what is working. Are you getting an error of some sort? What Form Event do you have this odd and finally, please provide your complete code and please remember to use code tags when you post it...

 

[isladogs]

Pardon me for jumping in...

Esso121
You may find this recent lengthy thread started by emm35 useful https://www.access-programmers.co.uk/forums/showthread.php?t=308264&highlight=Login

It builds on the Password Login example app