If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to scan for currupt DB.
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? -- Regards Tom |
#2
|
|||
|
|||
How to scan for currupt DB.
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 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ThomasAJ" wrote: 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? -- Regards Tom |
Thread Tools | |
Display Modes | |
|
|