troubleshooting Question

Data unexpectedly transformed into Chinese characters

Avatar of Alastair_White
Alastair_WhiteFlag for United States of America asked on
Microsoft Access
10 Comments1 Solution589 ViewsLast Modified:
Got to work this morning - one particular record in my Access 2003 back-end "Job Log" table, which is the central table around which my whole system is built is all of a sudden filled with Chinese characters.

Last night's backup was OK, so I tried replacing that record after compacting and repairing and deleting the record in the Job Log table - but the weird thing was that all the related records in other tables were still there.  I would have thought that the Cascading Deletes in the Referential Integrety business would have caused all the related records to go away.

Anyway I replaced the record in the Job Log, but when a user tried to access that job, all the data turned ito nubmer signs (not Chinese this time).  I compacted and repaired again, and deleted the record again, but the related records are still in the other tables.  Scary.  Help.  Is my world about to fall apart?

I did make some changes to the table yesterday - I changed a text field to a yes/no, but only after making sure the values were all "yes" or "no".  Could this be a catastrophic error?  Should I go to all related tables and manually delete all data associated with this one particular job number, then append the data from the backup?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros