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) asks: I 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.
Silver Members and up get access to an Extended Cut of this video. 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.
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. [ Ссылка ]
MEMBERS VIDEO:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
[ Ссылка ]
PREREQUISITES:
User Level Security Part 2: [ Ссылка ]
RECOMMENDED COURSES:
Access Security Seminar: [ Ссылка ]
Access SQL Server Online: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
How to Use Access in 30 Minutes: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
