Recently our power went out and although the backend was on a UPS, I have a feeling that some user's computers crashed. I now cannot access one of my tables and any form that accesses it gives me the error "Record is Deleted". Soon after the crash I was able to access the table and saw that for one record the word "deleted" appeared in every field. SO I did a compact and repair but I still got the same error. When I tried to delete the actual field, it appeared to delete it but whenever I closed the database and reopened it I got the "Record Is Deleted" error when I tried to open a form using the table and the record with the fields saying "deleted' was still there.
Finally, I ran the JetComp utility. Now I can't even open the table with the problem. I get the same "Record Is Deleted" error when I try to open the table. Any suggestions short of restoring my backup from the previous day?
Kim