Two weeks ago, my Access 2003 laptop bit the dust, stopped working, kaput. Doesn't matter how good your backup systems are its always tense when you go hunting for those files. In my case the main backups were created using Norton's 360 on a Terabyte drive and I had recovered files from there a few times so I wasn't too worried. But when I looked at the files from another PC using Norton's they weren't there. Norton's packs everything into an encrypted /file and Norton's from the other machines only showed the backups from that specific machine. An hour of madly typing in a Logmein session with a Nortons engineer at 3 in the morning and I finally worked out the trick that allowed me to recover the files from a different PC. It wasn't obvious in the help file etc You know the story... After the Easter weekend a Chinese guy at the local PC shop did a disk mirror and I got my older laptop working again so I was back to normal.
Moral of the story. Never rely on just having a backup system, its much more important to rely on testing the backup system with recoveries. Irrespective of what your backup system is, delete an unimportant file and then recover it. Once I tried this with a big company and they sheepishly said they couldn't, all their backup tapes were empty.
"Its the recovery that counts " Try it now.. Not next week Now.
Garry Robinson - Access MVP 2006-2011