I have an Access database, containing a single table that has all of the settings needed for the application. This table has several categories (Reports, User preferences etc).
Administrators are able to go into a form and make changes to those settings as required. However, if they make a mistake and wish to cancel those changes - they need a clean route to reverse. I am currently using a temporary table, which is OK, but I want to know if there is a better way that doesn't evolve copying data across to the temporary table first.
I was thinking of something such as setting the forms recordsource when it is opened to a clone of the actual live table but have never worked with clones, so don't know if; a: it's possible or, b: it's a good way to do it.
As always - I'm open to suggestions and any guidance is greatly appreciated.