User Authetication to access field names on a form

[sichilaba]

Good day



Iam using Microsoft access 2013.

I have a form with field names. I have 10 users who will be using the form for data entry. Users are only allowed to edit certain fields. How can l apply this in Access 2013?

Your step by step in this regard highly be appreciated

[JoeM]

If you have a multi-user environment, you should split the database into a back-end (which holds all the data tables) and a front-end (which contains all queries, forms, reports, macros, VBA, etc). Then you distribute a copy of the front-end to all the users. See this link for details on splitting databases: https://support.office.com/en-us/art...3-51b1d73498cc

Since each user has their own copy of the front-end (which they should be running from their hard drive), the easiest thing to do is create multiple copies of the front-end database (each with different Form fields locked, depending on your needs), and then distribute the front-end according to each user's needs.

Note that this isn't foolproof, as users could update any field if they go into the data tables directly. But the users shouldn't be doing that in a well-designed database; everything should be Form-driven (meaning users only access data through Forms). Here is a tip on hiding tables from plan view from users: http://www.techrepublic.com/blog/mic...em-from-users/

I haven't really done anything with Access Security, as Access built-in security features are notoriously difficult to use, and not great.

[sichilaba]

Hi Joe

Good to hear from you.

Well, my access database is just on one PC, Its neither a front end nor back end.

its is not a Multi user environment. Its a stand along PC. Users have their time slot to use the PC.

How do l lock up the fields?

[JoeM]

Does each user have their own login to the computer?
If so, does each have a secure folder on the network that only they can see?
If so, that is where you would want to put the different front-end versions.

Note, I should probably clarify, do you want all these users have to have the EXACT same access, or should different users have different access?

Regarding the locking question, there is a Locked property that can be set on each individual Text Box, Combo Box, List Box on the Form.

[sichilaba]

The database is placed on 1 PC Stand alone.
Users have access to database.
Users have been given time when to use the PC. eg. UserA 8:30 to 9:30, UserB 9:32 to 10, UserC 10:02 to 10:30 UserD 10:32 to 11:00, UserE 11:02 ot 11:30, UserF 11:32 to 12:00, UserG 12:02 to 12:30, UserH 12:32to 13:00, UserA I 1302: 13:30, UserJ 13:32 to 1400

Now how would l go about setting restriction to certain certain field that users are not supposed to edit? The Locking property, does it allow the use of passwords to allow the use to use allowed field? How does it work?

You see, this is a form where teachers come and enter their score in their subject areas. Teachers are not supposed to edit other subject fields. There are only allowed to edit their subject field on the form.And so l need a way to protect fields from being edited from unauthorized teachers.

One User is allowed access at a given time time. Remember this is a standalone PC.

[JoeM]

I am still on Access 2007, so I really cannot speak to setting up User Level Security, but I would recommend taking a look here: http://databases.about.com/od/tutori...ersecurity.htm