How to scan for currupt DB.

[ThomasAJ]

Every now and then a few records in some tables become corrupt.

How can I determine if corrupt records exists so that I do not end up with
ALL my backups containing corrupt records.

Is there a utility? or do I write a procedure to read thru all my tables?

 

[Jerry Whittle]

Good that you have backups. You could keep multiple backups so that you could
go back in time, but then you could lose newer data.

Best bet is to stop the problem from happening in the first place.
Corruption is not normal.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp