Avatar of peispud
peispudFlag for Canada asked on

Best practices when dealing with archived (not yet deleted) records


Using continuous form --- Microsoft Access database.

My database has thousands of product records.  Some of these products are archived from time to time.  
For those records [Archived] = True,   [Archive Date]  will be updated.

My question is about best practices.

1)  Should I move the records to another table?   If yes, then my question ends here.

If no,  then  what is "best practice" in dealing with the visibility of those archived records?
When the user is doing searches on the records,  I prefer that the results would never show those records where [Archived]  = True.  (unless  checkbox_IncludeArchives = true)

Currently, the record source for the form is a table.   So, should my

1) application automatically ensure  Me.FilterOn = True (at all times)  and modify Me.Filter (when user does a search)  to reject the archived data   (when checkbox_IncludeArchives = false)

2) application change record source to a query when checkbox_IncludeArchives = true

3) a better way?
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon
Máté Farkas

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Thank you for your prompt answer.  It's much easier to go down the correct road the first time. You helped me do that.
This saves a lot of needless work to correct this later.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.