access changed a record from english to chinese.

[Guest]

One of my associates has an Access 2002 DB that has three associated tables
in it. She was entering data on one record in a table. The record got
changed from english to chinese (or some other character set).

Access is now indicating that "the key search is not found" & something
about an index.

Is there a way to repair this single record?

 

[John Vinson]

One of my associates has an Access 2002 DB that has three associated tables
in it. She was entering data on one record in a table. The record got
changed from english to chinese (or some other character set).

Access is now indicating that "the key search is not found" & something
about an index.

Is there a way to repair this single record?

No; and in fact, this means that your entire database is corrupted.

See the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

You will need to create a NEW DATABASE; import everything except this
table; create an empty version of this table; and run an Append query
to append all *but* this one record. This record is gone for good.

John W. Vinson[MVP]

 

[Guest]

John:

Actually we tried the tools option in Access. There is an option for
Tools/Database Utilities/Compact and Repair. It "appears" to have corrected
the problem. If something reappears, we will try this other option.

Thank you,
Steve D