Error checking caused out-of-sync error that led to instability
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.
#1 Updated by Michael Lee over 12 years ago
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.
#3 Updated by Michael Lee over 12 years ago
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.