Thanks everyone! I did try rebooting but that didn't work, I'm not sure what compacting is. Could you explain that?
I did check references and nothing was missing, and I did check the data and nothing had changed. I'm really at a loss here!
Thanks again for your help!