[AccessD] Weird Problem...for me anyhow

I have a user who has setup her own DB...good that she has an interest in Access...bad that she THINKS she is capable of doing this. I have had to bail her out before, and once again my help has been requested. OK, so maybe I got a little chip on my shoulder w/this one ;o)

Anyhow, a fellow employee deleted some records and now there is some form of corruption going on. I am viewing this is A2K3 and, in one of the tables (CANDIDATES TABLE) there is a record where each of the fields says, "#Deleted."  And, in another table (EXAM LIST), which has a relationship w/the first table, if you press the "plus sign", to the left of each record...any record in the table...you get a pop-up saying, "Record is Deleted."

I tried to delete the record w/the "#Deleted" contents in it, but although you have to verify deleting one record, and it does appear to go away, if you leave the table and reenter it, the record is back.

I was extremely busy the last two days, so I tried the quick fix of creating a new DB and importing all the objects, but this did not work. It would not import the table, "CANDIDATES TABLE."

I was going to recover the DB, in a working state, from a backup tape, and just export a group of records that were recently input, out to there, but I'm not sure I can do this either. For one thing, I don't know if I can be sure to get all the related fields correct.

I am about to tell them, "Here is your recovered database. You will need to re-enter the data you've lost. Sorry!" But I wanted to run it by this list first.

Any ideas?!

John W. Clark