Bug #2751
closed
Error checking caused out-of-sync error that led to instability
Added by Michael Lee about 17 years ago.
Updated about 17 years ago.
Description
Forbes was error checking all plots (from the QA tab) and somehow got an out-of-sync error. Error checking needs to make sure all forms are not dirty before starting, then requery forms (trouble of keeping on same row...).
I have Forbes' database and should try to see what I can find out from it.
the memo field "headerrors" on entry_plots_stems was corrupted and was valued #Deleted and access couldn't do anything with that field value (not delete it or anything). This was fixed with a compact and repair.
TODO: need to add to general error checker that if this error comes up (3167 or -2147467259) to suggest compact and repair.
TODO: resolve whatever caused the write-write conflict.
done: need to add to general error checker that if this error comes up (3167 or
-2147467259) to suggest compact and repair.
remaining:
TODO: resolve whatever caused the write-write conflict.
added a command that refreshes all open forms before trying to reset the errors field to null or resolved.
also required that "Errors resolved" will only stick around for one error checking session.
also added link to errors form without doing the error checking.
Original Bugzilla ID was 2751
Also available in: Atom
PDF