User Level Security in Microsoft Access, Part 3

In this Microsoft Access tutorial I'm going to teach you how to make it so that users can only view and edit the records that they themselves have created. This is handy for example to make it so that sales reps can only see their own customers and not everyone else's.

Landon from Wausau, Wisconsin (a Platinum Member) writes: II have 3 sales reps who use my database. Is there any way to keep it so that they can only see their own customers and orders and not everyone in the system? I don't want to have to make them each their own database because I like to run reports based on everyone.

Disclaimer

This tutorial will show you security that is "good enough" to keep most users out of your database. However an experienced Access developer will be able to bypass this logon routine. To learn the best possible way to secure your database I recommend my Microsoft Access Security Seminar. 

• Access Security Seminar: https://599cd.com/Security

Members

Members will learn how to have it so that all users can view customer data but users can only edit or delete their own customer data. When it comes to deleting a customer we will first check to see if that customer has any orders and if so deny the deletion. We will then check to see if they have any contacts in the contact history table and if so will prompt the user again to make sure they're sure they want to delete him. And if the deletion is approved then we will run the SQL statements to delete the customer and all of his contacts.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Pre-Requisites

• User Level Security Part 2: https://599cd.com/UserLevelSecurity2

Recommended Courses

• Access Security Seminar: https://599cd.com/Security
• Access SQL Server Online: https://599cd.com/SQLOnline

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Complex delete routine for customer, check contacts, check orders, dont allow deletion if customer has orders, prompt if customer has contacts, allow filters, tempvars