Hi I'm a newbie here, hope anyone could help me. We're using an Access DB program as our personnel database, there’s no error on the program, but the weird problem is suddenly a record will contain Chinese characters. We'll just notice it on the reports when we saw somebody is missing. We'll look it up directly on the table and found out that his record was filled-up with Chinese character. I don't know on what part of the program was causing it, since there are no error message. It just happens suddenly on random records.

Could be a setting on your machine, but then again it could be something like a corrupt language file.

Last resort to try would be to reinstall access, but no-one likes having to do that.

Check to see if you have an IME for Asian characters enabled on your system. Also check the IME settings for the field(s) where the characters are appearing. (Properties/Other/) There are three fields that you can review. It appears that Access is converting some ASCII characters into double-byte east Asian pictographs. It would also be helpful to know whether the characters you're seeing are traditional kanji which is common to Japanese and Chinese, or are Japanese hiragana or katakana. That would give you perhaps a clue on how to proceed next.

Cheers

AvGuy

Is your database on network. I mean being used by many users ? If so, try setting of forms property ---Data-----Record Locks to Edited Record.

HTH
Ashfaque