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
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
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.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
Regards,
Bill
Glad we could shed some light on the subject.