N
Norm75
I was entering some data into my Access 2002 db. Suddenly, I was told that
Windows could not save the new data. After a couple of attempts, I eventually
rebooted the computer (closed out Access first). I found that in the three
records that didn't save, there was "#deleted" in every field of each record.
I attempted to delete the records but no luck.
I also found that I couldn't use one of my main queries - I got "Error 3167:
Record is deleted" even when I was searching for data that had no relation to
the original data I was trying to enter in the 3 records but was not saved.
I would think that somehow the db is corrupted?? How can I delete the 3
records and get the query to work? I have over 14,000 records so sure don't
want to have to start from scratch.
Many thanks. Norm.
Windows could not save the new data. After a couple of attempts, I eventually
rebooted the computer (closed out Access first). I found that in the three
records that didn't save, there was "#deleted" in every field of each record.
I attempted to delete the records but no luck.
I also found that I couldn't use one of my main queries - I got "Error 3167:
Record is deleted" even when I was searching for data that had no relation to
the original data I was trying to enter in the 3 records but was not saved.
I would think that somehow the db is corrupted?? How can I delete the 3
records and get the query to work? I have over 14,000 records so sure don't
want to have to start from scratch.
Many thanks. Norm.