troubleshooting Question

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

Avatar of peispud
peispudFlag for Canada asked on
Microsoft Access
2 Comments1 Solution26 ViewsLast Modified:

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?
Máté Farkas
SQL Server Consultant
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros