How do I apply permissions in Access

Access isn’t this best environment if you require strict security. You can implement the recommendations found at this page. I would also suggest you move your data to SQL server.

I believe Sharon is referring to User Level Security which is no longer available in recent versions of Access. https://support.microsoft.com/en-us/office/what-happened-to-user-level-security-69b362cd-503f-4e8a-a735-fb923ffb9fa3

I believe Sharon is referring to User Level Security which is no longer available in recent versions of Access.

Yep! That was what I thought.

"Step 2: Select Security from the Tool Menu, > Click on User and Group Permission."

Hmmm. A "Security" tab in an Access ribbon?

Can you provide a screen shot of how to get to that?

Hi Legion,

I’m Sharon one of the Independent Advisor and I’d be happy to help you out with your question.

Steps to Learn to Assign Default Permissions
Users can change permission setting for particular Tables, Reports etc or the whole database and make their interface more secure.

Assign Permissions In MS AccessStep 1: Open the database containing the Forms, Reports, Tables, Queries, and Macros.
Step 2: Select Security from the Tool Menu, > Click on User and Group Permission.
Step 3: Select User or Group, from the Permission Tab and then click on the group or user which already has the permission that you wish to assign to the Group/User Name Box.
Step 4: Go to Object Type box and select the object type and click on the Object Name list.
The selection will vary depending on the object type selected by the user.

Step 5: Now user needs to select the default setting that he/she wishes to assign to the object type and then apply them.
Step 6: Repeat step 4 and 5 for assigning default permission for any additional object type.
Note: User can only manage the Default Permission of the current database that is open.
Step 7: For adding additional groups or users, repeat step 3 to 5 and then finish the process by clicking on Ok.
Steps to Change Assign Default Permissions in MS Access
Users can change default permission, by updating and allowing new groups or users to access the database of a particular category. Users can also allow other users to view data, which has returned from queries or action queries, to run queries, even if their permission is restricted from viewing the query or table in the subject.

This feature comes in handy for a big organization, with loads of data in their system. They can use this method to change and manage Default Permission for their resources allowing users to access the information when required.

Step 1: Select Options from the Tools menu.
Step 2: Click on Table/Queries Tab.
Step 3: Click on Run Permissions that user wants to use.
Things to keep in Mind while Assigning Default Permissions
If a user selects Owner’s: All users will have owner’s query permission to run or view the query.
Only query owner is eligible to save change in the query.

Only query owner is eligible to change the ownership rights of the query.

If a user selects User’s: Permission granted under the classification of users, will have the permission to use it. And users with Administer permission are eligible to save and make changes in its query. The administering user can also change its ownership.
Users working on MS Access can occasionally come across a corrupted Access file.

Reference:

https://www.datanumen.com/blogs/assign-change-default-permissions-ms-access/

You may check this links for more details:

https://www.accessrepairnrecovery.com/blog/manage-user-permissions-in-access-database

https://www.uwec.edu/kb/article/drives-establishing-windows-file-and-folder-level-permissions/

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

I hope this information helps. If you have any questions, please let me know and I’ll be glad to assist you further.

Best regards,
Sharon