User Level Security

mohammadagul

PrinceAtif
Local time
Today, 19:59
Joined
Mar 14, 2004
Messages
298
I have a small problem here

I was creating a human resource database for a large firm. The number of records ranges from 5000 to 6000. Initially everything went well. My designs and development were highly appreciated. But now because of just security my DB is being rejected. The problem aroused because of the security issues. I tried using the Logging On database as presented here in the Code section of this Site. But it was completely rejected by the authorities. They wanted something like following

1. The administrator has the power to give the user special privileges like mentioned in the User level security i.e making users like read-only, backup, data entry etc
2. The administrator has the power to block any user from opening any form whenever he likes.

When I presented them with the user level security as in Ms Access they were completely lost and they find it really difficult to use. Further more the names of the forms as I have used are starting with “frm” where as they want only the simple names of each form. If I start changing my form names I would complete mess up my DB

Please advice what should I do to make the user level security easy for them to use.
Or how can I develop my own security system in which user can use my above mentioned points.
 
What version Access do you have?

I know A2003 has a User Security Wizard in the Tools menu. Start with that.

If you have an earlier version, you search "User Security" in the help file search.
 
Litwin, Getz, et al.'s Access Developer's Handbook has extensive DAO code for user security. With that you could satisfy most any requirements and required functionality.

I'm not certain where your clients are encountering "frm". I can understand them not wanting "programmer speak." Are you using a switchboard to navigate through your program? If so, it's quite easy to always display user friendly names for everything.

Without more specifics on how you do things, it's hard to give specific advice. Can you post pictures of something that particularly objectionable.
 

Users who are viewing this thread

Back
Top Bottom