values in a record turned to chinese!!!

[Brad Pears]

I had a complaint from one of our users this morningstating that a record
that used to be in our customer database just recently was now missing...

When I went searching, I found the record alright... however, all of the
fields (except for the customer# which is an autonumber), was chinese!!!
Yes, actual chinese lettering!!!!

Here is a sample of the record...

CUstomer Status: d??????? ???
First Name: ?????????? ? ?

etc.. etc..

This is obvious corruption but I have NEVER seen this before!!

Has anyone ever had this problem with an access DB??


Thanks,

Brad

 

[Allen Browne]

Hi Brad

Yes, this kind of corruption indicates that a pointer is bad. It is most
common with memo fields, but could also be a record pointer that has gone
AWOL.

You can probably rebuild the table by copying the other records into another
table. Sometimes the copy fails when it reaches this record, and so if the
ID is 99 then you must not refer to this record, i.e. use criteria of:
<=98 OR >=100

There's more info on handling different kinds of corruption in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
There's also a link there on preventing corruption.

 

[Brad Pears]

Thanks for the help and the links!!! Appreciate your help...

Brad