Speakeasy forum

General discussion

Any MS Access or file recovery gurus here?

by Josh K / February 27, 2006 2:05 AM PST
Discussion is locked
You are posting a reply to: Any MS Access or file recovery gurus here?
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Any MS Access or file recovery gurus here?
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
See if this free program
by TONI H / February 27, 2006 2:17 AM PST

can help recover the file.....the 'out of disk space' part worries me in that there may not be enough room to recover it, but you can try at least.

FREEWARE:

Restoration - file undelete utility
D O W N L O A D
Restoration 2.5.14 Kato's own link at http://www.geocities.jp/br_kato/

http://www.snapfiles.com/get/restoration.html

Restoration is an easy to use and straight forward tool to undelete files that were removed from the recycle bin or directly deleted from within Windows, and we were also able to recover photos from a Flash card that had been formatted. Upon start, you can scan for all files that may be recovered and also limit the results by entering a search term or extension. In addition, it also provides the option to wipe the found files beyond simple recovery. The program is small and standalone, it does not require installation and can also run from a Floppy disk. Restoration works with FAT and NTFS as well as digital cameras cards.

RESTORATION:

Restore files which are deleted from the recycle bin by mistake. Conversely, delete files completely.

[OS] Windows 95 Windows 98 Windows Me Windows NT Windows 2000 Windows XP
IBM-PC/AT Compatible PC [Author] Brian Kato

REST2514.EXE 193 KB

Also here:
http://www3.telus.net/mikebike/RESTORATION.html

Restore files which are deleted from the recycle bin or deleted while holding down the Shift key by mistake. Conversely, this program has another function that makes it almost impossible to restore all deleted files. You can use it after deletion of confidential documents, embarrassing files and so on.

You don't have to install it, so it doesn't leave any garbage in the PC. (You can also run it from a floppy disk.)

I also use a program called Easy Undelete...real simple. It's about $30 and worth every dime....

The Demonstration version of Easy Undelete 3.0 is fully functional and identical to the Standard version, but can only recover files smaller than 32 Kb.

For a comprehensive list of features in the Standard version, see http://www.easy-undelete.com/features.htm.

For ordering information, see http://www.easy-undelete.com/buy.htm.

TONI

Collapse -
Hi Toni, the file wasn't deleted
by Josh K / February 27, 2006 2:25 AM PST

It's corrupted.

Collapse -
Can you open any
by TONI H / February 27, 2006 2:49 AM PST

of the MS Office programs, click Tools in the toolbar and Repair Office? Have the cd handy if you can.

TONI

Collapse -
I don't think Access itself is damaged
by Josh K / February 27, 2006 3:00 AM PST
In reply to: Can you open any

I'm busy rebuilding my reports now, and am not having any problems doing so. I'm resigning myself to having to do this.

Collapse -
RE
by dagdabrona / March 16, 2006 4:37 PM PST

Greetings,

I would like to add Active@ Undelete and Uneraser(for pure DOS) are the most powerful data recovery tools I've ever used before. It never failed me before and literally saved me once. I suppose you really give it a glance, you won't regret it.

http://www.active-undelete.com/

http://www.uneraser.com/

Collapse -
I don't see how a recovery service can help if you mean the
by Kiddpeat / February 27, 2006 2:22 AM PST

type that recovers trashed hard drives. If you need that kind of recovery, I have gotten pretty good results from GetDataBack when I was trying to recover data from a damaged hard drive. It's reasonably priced on an individual basis.

However, it sounds like your database file is corrupted. It's probably got pointers to nonexistant records. You need a utility that can extract undamaged records from the database.

Collapse -
(NT) (NT) Never pass on an oppertunity for a free lunch
by duckman / February 27, 2006 2:36 AM PST
Collapse -
It wouldn't have been free.....
by Josh K / February 27, 2006 2:38 AM PST

...since I was not going to be paid for my time, time that I'm now spending rebuilding the database. Oh and I was headed for the cafeteria to get myself a sandwich when I passed a conference room that had set its leftovers out for all to take, so I actually did get a free lunch out of it.

Still sucks though. I'm going to look into a regular backup solution for home as well. I back up some things regularly (like my MS Money file) but have been lax with others.

Collapse -
Josh, have you worked through...
by Edward ODaniel / February 27, 2006 3:48 AM PST

this one:
http://support.microsoft.com/kb/306204/

Also (you probably did but it doesn't hurt to ask) when you tried the module had you altered the strDBPath variable to point to the correct database?

Is the database on a network share? If the diskspace quota was exceeded it will cause it to corrupt.

Also, I assume you already tried using Access repair utility.
On the Tools menu, point to Database Utilities, and then click Repair Database.

Now point it to the name and location of the database you want to repair, and click Repair.

Now create a new blank database and try to import the tables and data from the repaired database.

Additionally have you downloaded and run JETCOMP.EXE?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q273956

Never used it but this might be worth a try:
http://www.vb123.com/fixaccess/default.htm

Also here is a link to someone who claims to be able to recover/repair Access relatively cheaply (depends on size and complexity) but think twice if any of the data is confidential or could be exploited.
http://www.everythingaccess.com/accessdatabaserepair.htm

Collapse -
Been there, done it
by Josh K / February 27, 2006 5:09 AM PST

Some of those solutions apply to damaged objects within a database; in my case the database itself was damaged.

It was on my local hard drive so there was no chance of it having been backed up by our IT dept.

I did try the repair utility, and I did remember to change the strDBPath variable. I also tried the JETCOMP utility.

I noted in the Office forum that the data itself was never in any danger as it resides on a SQL server. It was just all of my queries, reports, forms, etc. that got toasted. I've already rebuilt some of the most important ones.

Lesson learned. I'll be investigating better backup solutions for my home computers also.

Collapse -
Been there, done it
by Josh K / February 27, 2006 5:39 AM PST

Thanks for the links, Ed. Some are for recovering corrupted objects within a database (tables, etc.). In my case the database itself was corrupted. I did remember to set the strDBPath variable, I tried the built in repair utility and the JETCOMP utility.

Fortunately the actual data was never in danger; it resides on a SQL server. I just had to rebuild all of my queries, reports, etc.

Popular Forums
icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

FALL TV PREMIERES

Your favorite shows are back!

Don’t miss your dramas, sitcoms and reality shows. Find out when and where they’re airing!