Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!
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?
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?
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
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.
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)
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)
Zip typically shrinks by 10 X .... go figure ?
I also pinged Wayne.
BTW ... the 'other' so called repair services ... probably should ignore :-)
mx
I also pinged Wayne.
BTW ... the 'other' so called repair services ... probably should ignore :-)
mx
@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.
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.
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??
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??
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.
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
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!)
Bad news all round!
I'll see if the owner of the data has some form of backup (although that is not likely!)
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.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
mx