Undo changes

If you had:
Code:
tbPeople:
    PersonID
    FirstName
    LastName

You could have a replica:
Code:
tbPeopleHistory:
    Id
    PersonID
    FirstName
    LastName

Then, using an After Update table macro, you can make it Create a record and Set its fields. With that, each modification to your record is inserted in the history table and you'd have a history of changes that you could browse using a subform. It's a friendly approach.

Edit: grammur and stuff
 
Last edited:
I have created a Configuration form where the user can create backup copies and select the number they want to have. When you activate it, once you close the database, a file is created with the date and time, and the oldest is deleted to leave the number of copies selected.

This is the solution I have proposed.
 

Users who are viewing this thread

Back
Top Bottom