Protecting access to certain data

Hi Jacqueline

Sorry for the delay in answering this question.

In Access you can give certain people in your organization access to individual tables, forms, reports etc while preventing others from accessing them.

This is done by setting up database security and giving users permissions to interact with the database

To perform any activity in a database, user must have the appropriate permissions. These permissions fall into three categories, which are called permissions types:

- Permissions to work with data and execute procedures (object permissions).
- Permissions to create a database or an item in the database (statement permissions).
- Permissions to utilize permissions granted to predefined roles (implied permissions).

You can manually change database and object permissions for user and group accounts in a workgroup. It's advisable to assign permissions to groups, not to users, because each user inherits the permissions assigned to the group.

This is done in Tools Security. You can set up the groups And their permissions and then assign users to the relevant groups

Hope this helps

Carlos