Archive

[eacollie]

Any help on how to design archiving of records would be greatly appreciated.

Thank you.

 

[plog]

Any help to your specific situation would be greatly appreciated. What do you hope to achieve by archiving? What issues are you facing now that you think archiving will alleviate?

 

[EternalMyrtle]

Your question is a bit vague.

Are you hoping to create a history/audit table to store prior values and current values when changes to data are made?

If so, you may want to look at this: http://forums.devarticles.com/micro...dit-trail-of-all-edits-to-database-22382.html