Purge Database to another Table

  • Thread starter Thread starter TomP
  • Start date Start date
T

TomP

I have a large database and would like to know if there is a way to purge
certain records from a main table and move it to a new table. The new table
will be maintained for historical reference (and/or closed cases). It must
meet one of three conditions. The conditions will check certain fields for a
date. If any one of the fields have a date, then that record will be
transferred to another table.

The new table will maintain the original format and design.

Hope that makes sense. I would appreciate any suggestions and/or input.

Thank you!

Tom
 
Is there a reason why you need to transfer certain records to a duplicate
table?
Is it a one off? Will it be a regular occurrence?

Why not use a query instead to make certain records visible?
 
By no means I want to duplicate anything. I just wanted to "move" or
transfer closed cases from the main table to another table.

I'm aware that the database can hold a large number of records. It might or
might not be a concern. Right now, it's not an issue.

Anyway, did you mention that certain records could be tagged to be hidden?
I'm willing to explore that.

Thank you,
 
What scuba is describing what I do.
If you can identify by field already in the table which records should be
archived, you can use those field to determine which records should not be
included in your forms and reports. Instead of using a table for a record
source, use a query that is filtered by that criteria.

In My app, I have a boolean (Yes/No) field named xxxIsActive. (xxx
identifes the table) All the queries based on the table filter based on that
field.
 
Back
Top