archive records

[zozew]

Ive got four tables tblProfile linked to tblSerif and tblCase and that one inturn with tblHearings.

I have a working DB now and i want to archive certain records. And id love that to be an exact copy of my current table structure.

What is the best way to do it?

Should i make a "Archive" version of the tables and move the records there..? How do i move the records with relations to other tables and keeping the relations when its moved so the data goes into the right tables as per the current structure?

thx

 

[MarkK]

I doubt you need to archive records. What problem are you going to solve with this archive? Speed? Clarity?

 

[Dairy Farmer]

Have a yes/no field in your table called Archived. Default = No. If yes the record is archived.

In your queries you can show only record where Archived=No. The data is still available, but not used by default.

Queries, reports and forms can then use Archived to either dislay all, current or archived data as needed.

You would need a pretty big database to have the number of records slow it down. If this did happen the SQL would be needed.

 

[zozew]

I doubt you need to archive records. What problem are you going to solve with this archive? Speed? Clarity?

you have a good point there, i just thought of longevity....but when i think of it there will be about 10000 records per year and this system will probably not run for more then 3 so 500kb per record thats not more then 1.5GB ill just make a Archived field with YES/NO that would just filter it.

thx guys for the speedy responses