Question User-Level Security

[tjones]

In my reading I see that they have done away with user-level security in Access 2010 (stupid idea!). What I need to do is limit ENTRY access while giving view-only access to the database.

However I also need to grant entry access to 2 forms for everyone. Is there any way to do this?

 

[moto485]

Using a SQL server as the backend how is that going to be useful for various user access and permissions? I am just wondering as I don't know...

 

[tjones]

The problems are:
1) everyone in the department has access to the server, no login required.
2) I have no control of the server to set login
3) I need full access to add, edit, delete but need to restrict everyone else to just the two forms.

 

[RainLover]

Access has it's limits as far as Security is concerned.

But then so does SQL Server.

Both depend on your ability to write the code and the ability of another person to break your code. If Security is not set up correctly then it is useless. I would not be advising the use of SQL Server.

What you will need is the following and most likely more.

ALL passowrds must be kept secret. Not as easy as one would think.
ALL passwords must be changed (By force) every 20 to 30 days.
Rules need to be designed and implemented for the construction of a password. eg Min number of Characters, Use of Alpha/Numeric and or special characters. Passwords cannot be reused until there are a min number of changes. etc

The Backend needs to be password protected.
Users must not be able to logon without a valid User Name and Current Password.
All Toolbars must be disabled.
The Shift Key must be disabled and can only be enabled with yet another different password.
Two Tables are required. One for unique user names which contains a user level, like Admin or Read Only etc.
The other table to store current and recent passwords.

When the Database is opened it must verify the User Name and Password. Then obtain the user level and store that in a Global Variable.

When opening a Form authority must be set based upon the Global Variable.

Is this enough information to get you started.

Suggest you search each problem and if you can't find a solution create a new Thread leaving this thread for general questions. Just a suggestion.