access 97 problem

the long and the short is an idiot at work (not me) cut the records from the access DB that we were using, and apparently when they upgraded the office personels computers they didn't reenable the back up function on the replacement machine, so we are currently sans back up.
Basically what happened (from what I gather from phone conversation today) is the guyw as trying to print a listing of the current outstanding items from the last few days, so instead of saving to another personaly DB and working off of that, he instead started cutting from the master DB (yeah I know, I know. I didn't do the system up) and managed to remove ~95% of the data (some of which is not stored anywhere else for some parts of it). I've been tasked with one of 2 options, either reenter all as much data as possible from the hard copies or find a way to recover the missing info.

Any and all help/ideas I can get would be much appreciated otherwise its going to be a long and extremely tedious night tonight.

and no the didn't go to the recycle bin the assist manager checked that.

Also it sounds like they have opened/closed the program since it got cut, so the back up file has been removed (probably repeatedly)

You say you don't have backups, is it on a Windows 2003 file share that has volume shadow copy?

I think you're pretty much up the creek w/o a backup on this one....

Eezy_Bordone wrote:
You say you don't have backups, is it on a Windows 2003 file share that has volume shadow copy?

I think you're pretty much up the creek w/o a backup on this one....

nope I'm pretty much up the creek without a paddle.

Yep, we still work with Access97 extensively at my company (I know, I know) and there's really no tricks I can think of that will help you. Are there any backups from before the computers were upgraded? Even if it's a week old it would be way more useful then re-entering 95% of the data from a hardcopy. It may even be worth searching every network drive and/or harddrives from the old workstations (assuming the upgrade including installing new hardware) looking for copies as you never know if someone ever made a copy of the database (unless you've already spoken to all the employees). I had a guy in my company complaining about running out of harddrive space and upon checking his PC found he had dozens of backups of just about every database we had spread out across his drive that he'd forgotten about and was keeping "just in case". Freed up like 3gig by the time I'd deleted them all and re-assured him that we backup our servers every night.

-edit-
If this database was on one single workstation, then it's also possible you may be able to recover it using any number of various "un-erase" utilties available out there, but they tend to cost several hundred dollars. Most of the time you can get a free trial to scan the drive and see if it can find the files you want to recover first before deciding to buy. Though, the more file activities that happen on the effected drive the less chance you have of recovering anything. When something is deleted, it's not actually removed from the drive, it simply gets reset to "free space" and could be overwritten at any time. If the file recovery programs are run in time they can usually recover the files before the OS decides to write other data over top of where the file was stored. But if there's been a lot of disk activity since this has happened then the chances aren't so great.

Oh man, that sucks. Other than checking other machines for a copy, I don't know what to tell you.

Coincidentally, the same problem has been featured on the Daily WTF a few weeks ago. But humor requires distance, I suppose.

My only other advice is to use this example to the powers that be that you need a real backup solution if you don't currently have one or more money to expand the current one if you do.

May [insert deity here] have mercy on your fingers.

So yeah I spent most of the night entering data got probably 60% of the way through the data (its faster to enter it from scratch as very few outstanding tickets go past 2 months)
They do have a back up they just forgot to have it start backing up again when they upgraded the upstairs computers (its backed up to one of the office personels machine)
Oh well the rest is up to the AM and not my problem anymore, plus I get OT out of the deal.

doihaveto wrote:
Oh man, that sucks. Other than checking other machines for a copy, I don't know what to tell you.

Coincidentally, the same problem has been featured on the Daily WTF a few weeks ago. But humor requires distance, I suppose. :(

LOL that is almost exactly what happened minus the crashing part, and the guy managed to wipe out most of it in a single night.