Don't Delete! Marking Records Inactive. When and When NOT to Hard Delete Data in Microsoft Access

Learn when you should and should NOT delete data from your Microsoft Access databases. We will "soft" delete customer records by marking them "inactive." We'll prevent users from deleting them by setting the Allow Deletions property to NO. I'll show you how to open your customer form to show either Active or Inactive customers. You'll learn how to create a list of only Active customers to select from in a combo box to add a new contact.

Ben from Jamestown PA (a Silver Member) asks: I've got a lot of customers in my database that I know will no longer be buying from me. Some have retired. Some are deceased. I need to keep their records in my table for accounting purposes, but I don't want them cluttering up my reports and combo boxes. How can I remove them without deleting them? Same thing goes with discontinued products.

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to Archive data to a different table after a customer is marked inactive for 30 days. We will create a Contact Archive table, move the information to that table using an append and delete query, and then create a Union query to see how to put it back together again into one set of data, if we need to.

MEMBERS ONLY VIDEO:


BECOME A MEMBER:


LINKS TO TOPICS MENTIONED:
Get on my Mailing List:
Splitting Your Database:
Relationships:
Relational Combo Box:
Concatenation:
Union Query Expert 16:
Cascade Deletes:
Append Query:
Union Query:

ADDITIONAL RESOURCES:
FREE Access Level 1:
FREE Customer Template Database:
$1 Access Level 2:
Your Questions Answered:
Learning Connection 50% OFF:
Survey:
Richard's Blog:
Access Forum:
Twitter:



Email Me: amicron@gmail.com

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, should we delete data, flag as not in use, mark inactive, mark as deleted, archive data, soft delete, hard delete, discontinued, terminated, delete best practices

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

microsoft access,ms access,#msaccess,#microsoftaccess,should we delete data,flag as not in use,mark inactive,mark as deleted,archive data,soft delete,hard delete,discontinued,terminated,delete best practices,