For my project that uses Access2000, I need to create and maintain an Undo log, which will record all database updations made from a certain point of time to a certain point of time and then if the need be, the application should be able to undo these database updations.

I can record the SQL statements used to update the database fine, but how do I build the Undo functionality?

.