Corrupt Database Support

[Eric Kinateder]

What does a program like 'AccessRecovery'
(http://www.officerecovery.com/access/index.htm) do that Microsoft Acces
itself can't do?

I've got a corrupt database. I get a 'Microsoft Access has encountered a
problem and needs to close' error whenever Access tries to repair a damaged
database. When I downloaded the demo for 'AccessRecovery' it seemed to be
able to read the corrupt database and extract the data (or at least a portion
of it -- it's hard to tell because it's a demo version).

Why couldn't Microsoft offer this functionality?

 

[Joan Wild]

What does a program like 'AccessRecovery'
(http://www.officerecovery.com/access/index.htm) do that Microsoft
Acces itself can't do?

I've got a corrupt database. I get a 'Microsoft Access has
encountered a problem and needs to close' error whenever Access tries
to repair a damaged database. When I downloaded the demo for
'AccessRecovery' it seemed to be able to read the corrupt database
and extract the data (or at least a portion of it -- it's hard to
tell because it's a demo version).

Why couldn't Microsoft offer this functionality?

Have you tried compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

Another method than sometimes works is to create a new database and import
objects from the
old.

 

[Jamie]

Hi Eric,

Maybe they have.

I've always at least been able to extract data from a damaged database using
Microsoft Query with Excel. Why don't you try that first if you've tried all
the other standard ways of restoring a corrupt database. I have an article
on my site which shows you how and to make it really easy to follow I've
included lots of screenshots.


Goodluck,

Jamie

 

[Jamie]

Hi Eric,

Maybe they have.

I've always at least been able to extract data from a damaged database using
Microsoft Query with Excel. Why don't you try that first if you've tried all
the other standard ways of restoring a corrupt database. I have an article
on my site which shows you how and to make it really easy to follow I've
included lots of screenshots.

http://jamiessoftware.tk/articles/accesscorruption.html

Goodluck,

Jamie

 

[Eric Kinateder]

Jamie, thanks for the response. I tried all the options suggested on your
excellent page. Unfortunately none of them worked. I'm getting the
following errors:

1) http://www.code-slave.com/Access/access1.jpg
2) http://www.code-slave.com/Access/access2.jpg
3) http://www.code-slave.com/Access/access3.jpg

Thanks,
Eric