Making copies of your database during the working day
The following question came up as part of a newsgroup thread.
When you say "make a copy every hour or two", do you really mean that your normal practice during development is to retain multiple separate copies saved at 2-hourly intervals rather than simply overwriting a single backup copy every 2 hours?
Yes, because I'm a paranoid pessimist. And I'm proud of that label. You never know when something really weird might happen and you want a copy of an object from a few hours ago. Or you change your mind and decide you want to go back to an older copy of an object or two.
Within Windows Explorer it's really easy to click on the MDB, Ctl+C, wait a moment for the hourglass to disappear, then Ctl+V. Windows Explorer makes a copy of the file titled Copy of <insert your MDB name here>.mdb. Then Copy (2), Copy (3), etc, etc. Real easy.
At the end of the day or when I accumulate 5 or 10 I zip them up using Winzip's right click context menu into a zip file titled <insert your folder name here> zip. I then rename the zip file to <insert your folder name here> yyyy mm dd.zip i then move that zip to an archive folder, which I include on my backups. In a month or two I those zip files.