Archiving records

[NOTLguy]

I have a table that will accumulate a lot of records over time and wonder if there is an established method to archive part of the tables records periodically? Perhaps with parameters for a date period?

Regards,


Bill

[RuralGuy]

AFAIK there is no "established" method but here's the link I usually provide when the topic comes up: http://allenbrowne.com/ser-37.html

[NOTLguy]

AFAIK there is no "established" method but here's the link I usually provide when the topic comes up: http://allenbrowne.com/ser-37.html

Thanks, I think I will leave well enough alone on this.

Regards,
Bill

[RuralGuy]

Glad we could shed some light on the subject.