backing up Access tables from within application 1

[xwizardx]

In an application I've developed, I've found a need to be able to restore the original information to a data field that has just been edited on a form. This is simple if the field is bound to a query. If the field is bound to a table, though, there seems to be no way to get back to the original information since that data is modified when the field on the form is.

Is there some way to ensure that modified data can be restored?

Barry Davis, President
Small Business Computing

 

[dhookom]

There should be no difference between binding to a table or binding to a query. If you really need to be able to back out of changes, users can just press the escape key.
If you need something more robust, you can use unbound forms. Another alternative would be to push a record to a temporary table for editing and then updating back to the main table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]