Avatar of Patrick O'Dea
Patrick O'Dea
Flag for Ireland asked on

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?
Microsoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Patrick O'Dea

ASKER
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)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Zip typically shrinks by 10 X .... go figure ?
I also pinged Wayne.
BTW ... the 'other' so called repair services ... probably should ignore :-)

mx
SOLUTION
wayne_phillips

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Patrick O'Dea

ASKER
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??
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

OH ... 4 Kb ... yikes ... thing 4Mb
ASKER CERTIFIED SOLUTION
wayne_phillips

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Patrick O'Dea

ASKER
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!)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"although that is not likely"
:-(   :-(   :-(
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.