VBA to save as existing file name with current date appended

[gemma-the-husky]

^^^^
@Pat Hartman is spot on. It's really hard to force Access to not behave like Access. A database tries to save record changes at every opportunity, and there's no "back" button to undo this. Not only is there on back button, there's no need for a back button, or daily copies, but it does need thinking about what you are trying to achieve.