Foreign Characters (Japanese) appear in Database Table

[MSBECCA23]

Can someone help me figure out why one of the records in a table in my Access
2003 Database application displays the record in Japanese characters? The db
table gets populated by end users entering data in form fields and values are
written directly to database table. For some strange reason, one (1) of the
records appear as Japanese or Chinese characters...even the primary key field
value has been converted to foreign characters. How can I keep this from
occurring in the future?

 

[George Nicholson]

I've seen that happen, but only once. Essentially, you have a corrupt
record. I treated it as if I had a corrupted db and imported all objects
into a new, blank, db. The corrupt record did not survive the import
process, which was fine.

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm

Preventing corruption
http://allenbrowne.com/ser-25.html

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

A quick glance indicates that neither source specifically lists your case as
a "symptom" of a corrupt db. All I can say is that I would treat it as such.