Hello,



I would like to save the old records in a separate table every year. On the
end of the year I would Copy the empty main-table to an new table named like
"Backup" and the old year for example. The new backup table needs no
triggers.



How can I realize this?



Thanks.



Best regards.



Olaf







[Non-text portions of this message have been removed]