Daily records Backup programatically

[Moore71]

Hi guys,i have 2tables,table1=productid,ProductName,Qty table2=Productid,productName,Qty,date().
I want to be able to backup Records programatically daily from table1 into table2 OnClose.But i do not want duplication of record in the same day.
If changes occurs in table1 after backup,table2 should be updated Programatically.
Thanks in advance

 

[MarkK]

For backup I would just copy the whole file.

Copying records around inside your db is a design problem. Data should have an authoritative home inside your design, a place where it belongs. If you move stuff to a new table because of a change of status or the passage of time, then you have misunderstood how a database works.

If an attribute of a record changes, update the value of that field in the table, don't move the record.