Secure User Login System..

[HZM]

Hey ..
I'm looking for a secure user login system for my DB that has a Home form with 3 buttons: Invoices, Banks, Analysis.. each button has a macro that opens the form of the name on button..
So, i need to enable different users to login on the DB with different permissions.. like for the 'Juniors' to only open the Invoices button, add/edit on it but not delete and when trying to open other button a msg should pop up saying that it's not permitted, for the 'Seriors' to open all buttons but read only with no editing or adding, and ofc the 'Adminstrator' has all the access on all buttons..
Also, no one of the users can show the navigation pane or the hidden ribbon or show the design view or even enable any edit in the DB but ofc the adminstrator should be able to do everything since the adminstrator is the DB creator...!!

 

[KenHigg]

Are you looking for someone to build it for you or have you taken a stab at it and have gotten stuck?

 

[HZM]

Well, i saw many Login Samples but all of them i can enter the design view and edit it..
but i liked a sample was posted here in the Sample Database under the title 'IT Audits' that blocks everything even for the adminstrator (hidden the navigation pane, ribbon & the design view and other views..) so that i couldn't even see how it's created in the design view :/

 

[CJ_London]

Well, i saw many Login Samples but all of them i can enter the design view and edit it..

Wouldn't be much use as sample if you couldn't...

 

[HZM]

Yea, but it must be a user with no edits and admin with edits not all users with edits.. :/

 

[RainLover]

You have 2 Versions.

One for use by all which is locked up and converted to an .mde file.

The other is for the Administrator which is hidden away from every one. This is not converted to mde and stays as an mdb

An mdb is fully accessible.

You will still need to create the log in for the various users.