Corrupt accdb

Hi,

I am helping a third party.
I have an Access database that is corrupt.  Access 2007 .accdb file.

See 20 second video http://screencast.com/t/fRN0V0lLYy7

Message is "unrecognised database format"

I tried Compact & Repair but no joy.  I also tried "importing" table into another database but no joy there either.
I have also tried a couple of "try before you buy" database repair tools.

The tool "Stellar Phoenix" said "This is not a valid MS Access file"   - even though it's clearly a .accdb file.

How can I recover my data?  Should I pay someone to do it for me?  Any recommendations?
Patrick O'DeaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
If it can be fixed, Wayne at http://www.everythingaccess.com/accessdatabaserepair_info.asp  will be the one to fix it.  Highly recommend you contact Wayne. Note - he is in the UK ... take time zone into account for response.

mx
0
Patrick O'DeaAuthor Commented:
Thanks Joe,

I am now on this site.

Incidentally, when I zipped the database it was only 4kb in size .....
Does that seem very small??

(Reminder: it is not my database but I believe it's got a "fair bit" of data in it)
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Zip typically shrinks by 10 X .... go figure ?
I also pinged Wayne.
BTW ... the 'other' so called repair services ... probably should ignore :-)

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

wayne_phillipsCommented:
@Joe, Thanks for pinging me.

If the file ZIPs down that much, then it is very likely that your file is blank at the binary level.  You should be able to confirm this by opening the file with a hex editor (such as XVI32 available for free online), and upon opening the file you will see that the file only contains blank (zeroed) data, and as such is completely unrecoverable by this method.

Often this type of corruption is due to a hardware fault/failure (e.g. machine lost power when the file was being written too, or perhaps a harddrive or network failure).

I would suggest trying an alternative method of recovery, such as using Shadow Explorer (if available), or try a file system recovery tool to try to restore an older version of the file.
0
Patrick O'DeaAuthor Commented:
mmmm..... seems very small.  The unzipped file is over 3 meg.

I have loaded the database onto "everythingaccess".  I await response.

The user of the database is very unsophisticated.

All seems a bit bizarre..
The file is corrupt AND tiny.
Could there be a virus of some sort??
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
OH ... 4 Kb ... yikes ... thing 4Mb
0
wayne_phillipsCommented:
Just to clarify, I'm from EverythingAccess.com, and I can confirm that having reviewed the file you uploaded to us just now that my earlier diagnosis of the problem with your file was correct.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Patrick O'DeaAuthor Commented:
Thanks Joe & Wayne,

Bad news all round!

I'll see if the owner of the data has some form of backup (although that is not likely!)
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"although that is not likely"
:-(   :-(   :-(
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.