David Fenton posted in an earlier post this reference to some code for
dealing with a corrupt memo field
Tony Toews explains how to troubleshoot and correct corrupted
memo pointers:
http://www.granite.ab.ca/access/corruption/corruptrecords.htm
I looked at the code and do not understand why the line
If IsError(!tableMemoField)
should return an error if the memo field has a bad pointer?? ISError is
supposed to see if an expression is a valid numeric value.
As an alternative I have tried building vba code to loop through all
tables and all records and all fields looking for memo fields. For each
memo field, I copy the contents to a string field using the GetChunk
method.
Just got this code to work and have not yet tried it on a database with
corruption, one that produces an error 3167 when trying to sync. I read
a statement from David Fenton where he said such was "almost always a
corrupted memo pointer error".
Anyone else have experience with finding and fixing corrupt pointers to
memo fields?
Bob
bobalston9 AT yahoo DOT com
