Strange attribute table behavior

Discussion created by Waterrob on Dec 21, 2012
Latest reply on Apr 30, 2013 by Rosemary1979
Hi all,
  I switched to 10.1 yesterday, and am having a rather odd issue. When I open an attribute table for any of a series of unioned polygon feature classes, I get an SQL error message, saying it can't load the data. However, if I select all or query a selection or select manually from the map, the selected records are visible. Also, if I open an edit session on the feature, all records are suddenly there. It is only happening in 10.1; if I go back to my other machine with 10.0, everything opens just fine. Attached is the error message that pops up when I try to open the attribute table. I have tried saving a copy as a 10.0 mxd to see if that helped, but it didn't.
Any ideas, or has anyone else run in to this?