Password Protect

[Mattymatt79]

Yes i know i can password protect a database and that is all well and good, but my question to the group is this
Can i set up like a form that will grant specific user access rights to just certain areas of the database and then allow for like an administrator super password that will allow it to get around the shift key thing and not have to worry about that?
Yes im sure i could do this through Windows passwords and the server stuff, however I dont have any access to the server.
Uh, if anything else needs to be done, Id prefer this to be through a Form that way it will be set up so they can click and stuff, my users are not the most computer savy people and i dont want a point click and mistake error

 

[Hayley Baxter]

You can set up your own security by using a table to store users names although I am not too familiar with this because I have never used it. You can use the security wizard in access to do this also and that way you can add users names and passwords and give them rights to specific areas of the database. As for disabling the shift bypass key I have a demo which does that. If you want it just drop me an email.

Hayley