fixing corrupt mdb files

[John Milbury-Steen]

I am using Access 2002 for Windows XP. Recently an .mdb file became corrupt
and Compact and Repair did not solve the problem. I spent hours on the
problem until I found a funny looking entry in a table, deleted the record,
and found that the table's key field was no longer the key, and it had lost
a join to another table. Reconnecting the joins did the trick.

Can anyone suggest a good free article on fixing corrupt mdb files?

Can anyone suggest reliable, cheap software that will automatically do what
I did?

 

[Larry Linson]

Can anyone suggest a good free article
on fixing corrupt mdb files?

The best collection of information and links on the subject that I know
about can be found at Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Can anyone suggest reliable, cheap
software that will automatically do what
I did?

I am unaware of any Compact / Repair software for Access databases, other
than the builtin Compact and Repair and the JetComp utility that you can
download from the Microsoft web site.

 

[John Vinson]

Can anyone suggest a good free article on fixing corrupt mdb files?
http://www.granite.ab.ca/access/corruptmdbs.htm

Can anyone suggest reliable, cheap software that will automatically do what
I did?

No, because no such software exists. Corruption is multifaceted and
what will cure one corrupt database may irrevokably destroy another
one.


John W. Vinson[MVP]
(no longer chatting for now)

 

[fyz]

Hi,

Just post to hope my experience will help.

I think you can try a utility called Advanced Access Repair to repair your Access mdb file. It works rather well for my corrupt Access mdb files. Its web address is http://www.datanumen.com/aar/

Alan