Error 3167 #deleted

[Guest]

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.

 

[Guest]

Hi Norm,

Have you tried a compact and repair? If you are lucky, that's all it will
take:
Tools > Database Utilities > Compact and Repair Database

If this does not work, then you can try the methods outlined in these
articles:

Recovering from corruption
http://allenbrowne.com/ser-47.html

Recover records from a corrupt table
http://www.mvps.org/access/tables/tbl0018.htm

How to troubleshoot and to repair a damaged Access 2002 or later database
http://support.microsoft.com/?id=283849

How to recover data from a damaged database table or a corrupted
database table in Access 2000, Access 2002 or Access 2003
http://support.microsoft.com/?id=247771


If you still have no joy, then a data recovery service, such as this one:
http://www.pksolutions.com/


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Many thanks, Tom. Nice to hear from you again and thanks for all your help on
an earlier occasion.
Regards, Norm.

 

[Guest]

Hi Norm,

Are you the same Norm H. from Vancouver, BC., associated with CESO? If so,
how have you been doing? Feel free to send me a personal message if you'd
like.

I take it you were able to get rid of the #deleted errors?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________