|
||||||
|
Don't Delete Data By Richard Rost 4 years ago Don't Delete! Marking Records Inactive. In this Microsoft Access tutorial, I will teach you when you should and should NOT delete data from your 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. MembersI'll 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.
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! Links
|
||||||||||||||||
| |||
Keywords: TechHelp Access do not delete dont delete 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 PermaLink Don't Delete Records in Microsoft Access |