Has anyone seen what appears to be Chinese characters in 2003?

B

Bug Master

At times I see a record appear in 2003 as if some or part of a record is in
Chinese and other parts of this same record has changed to extremely large
number (in the millions). I usually see this phenomenon after importing
records from other Acess version, 2000 or XP. Please let me know if you know
what would cause this to occur?
 
A

Allen Browne

The problem indicates either that there is a corruption in the database, or
else that the import process did not understand the intended data type of
the imported fields.

If any of the import fields are calculated fields, explicitly typecast them.
Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
This problem can also occur with UNION queries, or stacked queries, or
totals queries, or any other type of query where JET can get the data type
wrong.

It may also help to ensure that your machine(s) have the lastest version of
JET 4, available from:
http://support.microsoft.com/gp/sp

If you believe there may be a corruption, see:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
Top